Answers for "get alternate rows in sql"

SQL
1

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
0

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 "SQL"

Browse Popular Code Answers by Language