for example,if you want to have records from 10 to 20
do
select * from emp where rownum < 21
minus
select * from emp where rownum < 11;

Dragon