How to display the 10th record of emp table(without using rowid) ?

Oracle Apps Interview Questions › Category: SQL › How to display the 10th record of emp table(without using rowid) ?

0 Vote Up Vote Down

Questions Master asked 10 years ago

How to display the 10th record of emp table(without using rowid) ?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

SELECT * FROM emp WHERE rownum < 11
MINUS
SELECT * FROM emp WHERE rownum < 10;