Sql query to find EVEN & ODD NUMBERED records from a table.

                                                                                                                                                                      

Scenario:

 Sql query to find EVEN & ODD NUMBERED records from a table.

Solution:

Even - select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) from emp);

Odd - select * from emp where rowid in (select decode(mod(rownum,2),0,null ,rowid) from emp);