oracle分页

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

xiaoxiaode_shu

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

阅读量8.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.csdn.net/xiaoxiaode_shu/article/details/90709695

Oracle 专栏收录该内容

1 篇文章

订阅专栏

博客展示了一段SQL查询代码，从QYXZ_BASE_GRID_SCORE表和BASE_GRID_NUM_INFO表中查询特定GRID_ID的数据，包括GRID_ID、CITY_RANK等多个字段，通过左连接关联两表，按CITY_RANK降序排序，并根据rownum限制查询范围。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select GRID_ID,
       CITY_RANK,
       LAST_CITY_RANK,
       HOT_SCORE,
       FEE_SCORE,
       HIGHPAY_SCORE,
       TOTAL_SCORE,
       PEOPLE_NUM from(select rownum,a.GRID_ID,
       a.CITY_RANK,
       a.LAST_CITY_RANK,
       a.HOT_SCORE,
       a.FEE_SCORE,
       a.HIGHPAY_SCORE,
       a.TOTAL_SCORE,
       b.PEOPLE_NUM
       FROM "QYXZ_BASE_GRID_SCORE" a
       left JOIN BASE_GRID_NUM_INFO b
       on a.GRID_ID = b.GRID_ID
       where GRID_ID IN
       <foreach collection="grids" item="item" index="index" separator="," open="(" close=")">
           #{item}
       </foreach>
       and rownum <= ${end}
       order by a.CITY_RANK DESC
       ) where rownum > ${begin}