select * from (select * from table order by ID) where rownum<=20
minus
select * from (select * from table order by ID) where rownum<=10
minus
select * from (select * from table order by ID) where rownum<=10
调试欢乐多
select * from(select a.*,rownum rn from(select * from table_name order by id) a where rownum<=N) where rn>=M;