Answers for "How can we retrieve alternate records from a table in sql?"

how to get alternate records from a table in sql

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

Posted by: Guest on January-28-2021

How can you get the alternate records from the table in the SQL?

SELECT EmpId from (SELECT rowno,EmpId from Emp) WHERE mod(rowno,2)=1;

Posted by: Guest on April-29-2021

Code answers related to "How can we retrieve alternate records from a table in sql?"