select * from (select .... renyb from .. where .. order by renybh) where rownum<=20
minus
select * from (select .... renyb from .. where .. order by renybh) where rownum<=10;
minus
select * from (select .... renyb from .. where .. order by renybh) where rownum<=10;
select * from (select .... renyb from .. where .. order by renybh) where rownum<=20
minus
select * from (select .... renyb from .. where .. order by renybh) where rownum<10;
minus 操作不被支持啊
我是通过Oratools 调试语句的
select * from (select rownum rm,a.* from (select .... renyb from .. where .. order by renybh) a ) where rm between 10 and 20 ;