方法一:
select * from tablename where rownum<=10; (取1-10行)
select * from tablename where rownum<=20
minus
select * from tablename where rownum<=10; (取11-20行)方法二:
select * from (select rownum rn,tablename.* from tablename) where rn<10; (取1-10行)select * from (select rownum rn,tablename.* from tablename) where rn>=11 and rn <=20; (取11-20行)
select * from tablename where rownum<=10; (取1-10行)
select * from tablename where rownum<=20
minus
select * from tablename where rownum<=10; (取11-20行)方法二:
select * from (select rownum rn,tablename.* from tablename) where rn<10; (取1-10行)select * from (select rownum rn,tablename.* from tablename) where rn>=11 and rn <=20; (取11-20行)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货