Select alternate rows from SQL

• Use the modulo operator to filter alternate rows

• Add a WHERE clause with the modulo operator

• Example: SELECT * FROM table WHERE id % 2 = 0

• Example: SELECT * FROM table WHERE...read more

select * from (select rownum as Rnum, A.* from employee A) where mod(Rnum,2) = 1; It will give odd records only from the table

select * from (select rownum as Rnum, A.* from employee A) where mod(Rnum...read more