用minus取 3000和5000的差值
----排序后取序列为3000-5000的数据
select * from table_name t where rownum<=5000 order by t.sn asc
minus
select * from table_name t where rownum<=3000 order by t.sn asc;
用minus取 3000和5000的差值
----排序后取序列为3000-5000的数据
select * from table_name t where rownum<=5000 order by t.sn asc
minus
select * from table_name t where rownum<=3000 order by t.sn asc;