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


--To display the the ODD records

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
span style="font-style: italic;">--to find even rows in a table


--to find even rows in a table


--to find odd rows in a table

Ram

• Feb 6th, 2013

 

Code