Here is the example out of the Oracle Dcoumentation for Top-N query

Select * from
(select class_id, crs_id, start_date
from classes
order by start_dat DESC)
where rownum < 10;


Eric Yen