Oracle: how to display Odd/ Even number of records?

Answer 1

To Display Even numbers of Rows:

Select * from emp where (rowid,0) in (select rowid,mod(rownum,2) from emp);

To Display Odd number of Rows

Select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp);