HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?

Oracle Apps Interview Questions › Category: SQL › HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
0 Vote Up Vote Down
Questions Master asked 9 years ago

how to display 5 to 7 rows from a table?

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

SELECT ename
FROM emp
WHERE rowid IN
  (SELECT rowid FROM emp WHERE rownum<=7
  MINUS
  SELECT rowid FROM emp WHERE rownum<5
  );