How to select odd number records from a table?

Oracle Apps Interview QuestionsCategory: SQLHow to select odd number records from a table?
Questions Master asked 2 years ago
1 Answers
Shailender Thallam Staff answered 2 years ago

SELECT * FROM emp WHERE (rowid,1) IN
  (SELECT rowid, mod(rownum,2) FROM emp
  );