Friday, July 13, 2012

Oracle: limit results like Mysql limit clause

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

No comments: