look into rownum extension, see an example here:http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid500221_tax285650,00.html..........To query the 10th to 19th records in Oracle 8i+, you can issue the following query: select *
from ( select a.*, rownum r
from ( select * from my_table
where col1='some_value' order by col1 )
a
where rownum <= 19 )
where r => 10;
from ( select a.*, rownum r
from ( select * from my_table
where col1='some_value' order by col1 )
a
where rownum <= 19 )
where r => 10;
minus
select * From table where rownum<=5