[注意]
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