方法一:
select * from?
?????? (select rownum as my_rownum,a.* from?my_table? where rownum<20000)
where my_rownum>=10000
方法二:
select * from my_tablewhere rownum<=20000 minus (select * from my_table where rownum<10000)
相比较而言,方法一的效率要高的多。
方法一的改进:
去掉my_rownum字段
select c.* from?
?????? (select rownum as my_rownum,a.* from? my_table? a? where rownum<20000) b ,my_table? c
where my_rownum>=15000 and c.id = b.id;