Compare against ROWNUM:
select * from >myTable where ROWNUM <= 5;
Reference:
http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering
select * from >myTable where ROWNUM <= 5;
Reference:
http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering
No comments:
Post a Comment