how to get alternate rows in sql code example
Example: how to get alternate records from a table in sql
Select studentId from
(Select rowno, studentId from student) where mod(rowno,2)=1
Select studentId from
(Select rowno, studentId from student) where mod(rowno,2)=1