Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Retrieve particular rows ?.
AFAIK the rownum value gets assigned before the order by takes
place. This means that the order by is only being applied to the
first ten rows that would normally be retrieved without the order
by clause.
Luke