Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
select * from foo where rownum < 11;
-- at least from 11g. IDK about older ones
It used to be a lot worse
Order by id
Where ROWNUM <= 10
coffeeholic138614dIn the first versions when the fetch first was introduced I've read a blog post that the rownum version had better performance.