方法一:rownum法
方法二: minus法
select * from
(select t.*, rownum rn from empt where rownum <21)
where rn > 10;
方法二: minus法
select * from emp where rownum<21
minus
select * from em where rownum<10