Forum OpenACS Q&A: Response to is there something like LIMIT for a query in Oracle?

Collapse
2: Response to is there something like LIMIT for a query in Oracle? (response to 1)
Posted by C. R. Oldham on 02/19/02 03:54 PM
Oracle has a special field called "rownum".  So you can say

select user_id from users where rownum < 10;

Unfortunately it does not always behave like you would think.  It is calculated on the fly, so

select user_id from users where rownum > 500

won't get you what you want.