how to select 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