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
|
Results 1 to 8 of 8
Threaded View
|
Click Here to Expand Forum to Full Width |