oracle分页查询SQL

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

MoonlightCloud

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

阅读量2.3k

点赞数

分类专栏：数据库相关文章标签： SQL

本文链接：https://blog.csdn.net/u012173417/article/details/90691561

版权

数据库相关专栏收录该内容

3 篇文章 0 订阅

订阅专栏

分页查询，第二页，每页10条数据

select * from ( 
    select row_limit.*, rownum rownum_ from (
        select count_num.*, count(1)over() totalnum_ from (
          select * from mdkzwmx where lgrpcd ='9999' and bzbrch ='0098' and recdst = '0' order by loancf,detlsq 
    ) count_num  
  ) row_limit where rownum <= 20 
)where rownum_ >10