DISPLAY TOP N ROWS FROM TABLE?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 658
SELECT * FROM (SELECT * FROM EMP ORDER BY ENAME DESC)
WHERE ROWNUM <10;

Comments or Responses

Login to post response