viji_info

 Profile Answers by viji_info Questions by viji_info

• Oct 22nd, 2010

 

SELECT * FROM table WHERE (primary key column,1)=0

AnithaLetchumi

 Profile Answers by AnithaLetchumi 

• Aug 10th, 2011

 

Code
--To display the the EVEN records


 


SELECT column_name FROM(SELECT rownum rowno, column_name FROM table_name) WHERE mod(rowno,2)=0


 


--To display the the ODD records


 


SELECT column_name FROM(SELECT rownum rowno, column_name FROM table_name) WHERE mod(rowno,2)=1

karthikeyan

• Sep 22nd, 2011

 

--Use this Script in SqlServer

Select * from (Select *,Row_number()over(Order by Sno) as Row From TableName)A
Where (Row%2)<>0

Millar

• Jul 26th, 2012

 

Code
SELECT * FROM table_name WHERE mod(primary_key_column,2)=0 --to find even rows in a table


 


SELECT * FROM employees WHERE mod(employee_id,2)=0 --to find even rows in a table


 


SELECT * FROM employees WHERE mod(employee_id,2)=1 --to find odd rows in a table

Ram

• Feb 6th, 2013

 

Code
SELECT * FROM EMP 


WHERE (ROWID,1) IN (SELECT ROWID,MOD(ROWNUM,2) FROM EMP);


 


OR 


 


SELECT * FROM (SELECT EMP.*,ROWNUM K FROM EMP)


WHERE MOD(k,2)=0;