[注意]
1、rownum 不能直接使用> .
2、需要先排序,过滤以后再处理rownum
i、minus
这个方法因为用到了minus操作符,所以速度会受影响
select rownum,c1.* from (select t.* from carrier t where .... order by...) c1 where rownum <= 8
minus
select rownum,c2.* from (select t.* from carrier t where .... order by...) c2 where rownum <= 8
ii、select嵌套(3层)。
SELECT *
FROM (SELECT rownum rownumber, c.*
FROM (
select t.* from carrier t where .... order by .. .
) c
) cc
WHERE cc.rownumber > 8
and cc.rownumber <= 10