MY mENU


Monday 16 April 2012

Display Odd/ Even number of records


Odd number of records:


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


Even number of records:


select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp)
2
4
6

No comments:

Post a Comment