Display Odd/ Even Number Of Records?

1.	Display Odd/ Even Number Of Records?
Answer» 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. Odd number of records: Even number of records:

Answer»

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.

Odd number of records:

Even number of records:

Discussion