How to do the query

Question

Hi friends What will be the query to Display Odd/ Even number of records in oracle Thanks

Satyapriya Nayak · Answer

Hi Bibekanand Welcome to c-sharpcorner community. Here is your query Even number of records: select * from emp where (rowid0) in (select rowid mod(rownum2) from emp) Odd number of records: select * from emp where (rowid1) in (select rowid mod(rownum2) from emp); Thanks If this post helps you mark it as answer