DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers
Display Odd/ Even number of records
More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
67. 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
(Continued on next question...)
Other Job Interview Questions