oracle中用sql分页的两种方法

最新推荐文章于 2024-08-19 08:45:16 发布

zhangyp

最新推荐文章于 2024-08-19 08:45:16 发布

阅读量1k

点赞数

分类专栏：随便写写文章标签： oracle sql

本文链接：https://blog.csdn.net/zhangyp/article/details/391474

版权

随便写写专栏收录该内容

3 篇文章 0 订阅

订阅专栏

--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)