negative, Rownum is not determined till after the ordering is done.
I don't think this is correct. You have to use a subquery to get the results you want, because sorting happens after the rownum assignment as so:
select name, salary
from (select name, salary
from emp
order by salary desc)
where rownum<10
I remember having a question like this for the 007 cert exam.
John
