how to get alternate records from a table in sql

Solutions on MaxInterview for how to get alternate records from a table in sql by the best coders in the world

showing results for - "how to get alternate records from a table in sql"
Samantha
23 Jan 2020
1Select studentId from
2(Select rowno, studentId from student) where mod(rowno,2)=1