Search Here

Tuesday, December 08, 2015

how to show only even or odd rows in sql server

Odd No:- 
 SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY sal DESC) row_number, sr,sal 
 FROM empsal) a WHERE (row_number%2) = 1

Even No:-
      SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY sal DESC) 
row_number, sr,sal FROM 

No comments:

Post a Comment