How to display 9th record from EMP table?

Oracle Apps Interview Questions › Category: SQL › How to display 9th record from EMP table?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to display 9th record from EMP table?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

SELECT ename
FROM emp
WHERE rowid=
  (SELECT rowid FROM emp WHERE rownum<=9
  MINUS
  SELECT rowid FROM emp WHERE rownum <9
  );