oracle中用sql分页的两种方法

--pagezize=5;page=2
select * from
    (
       select * from
         (
        select depname from
         (
              select depname from department order by depname
         )
          where rownum<5*2
    )  
     order by depname desc
  )
  where rownum<5
--pagezize=5;page=2
select a.* from (select * from department order by depname) a where rownum<10
minus (select * from  (select * from department order by depname) b where rownum<5)