How to do the query

Hi Bibekanand,

Welcome to c-sharpcorner community.


Here is your query


Even number of records:

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


Odd number of records:

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




Thanks
If this post helps you mark it as answer