how to get alternate records from a table in sql
snippet in sql

how to get alternate records from a table in sql

user1001

Select studentId from
(Select rowno, studentId from student) where mod(rowno,2)=1