Oracle MYSQL DB2 sql分页-优快云博客

本文详细介绍了在Oracle、MySQL及DB2中实现SQL分页查询的方法。针对不同数据库的特点，提供了具体的SQL语句实例，包括如何使用ROWNUM、LIMIT及ROWNUMBER() OVER等函数进行分页操作。

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

Oracle MYSQL DB2 sql分页

Oracle , MYSQL , DB2 , sql , pagination

Oracle

select * from (select rownum,name from user_tables where rownum <= endIndex)
where rownum > startIndex

如果加了order就更麻烦了

select * from (select rownum,name from user_tables order by orderstr) where rownum <= endIndex
and rownum > startIndex

Mysql最简单
limit

select * from tablewhere whereclause order by orderstr limitstart,pageNum

DB2
使用rownumber over和fetch first rows only

select * from (select syscat.indexes.*, rownumber() over() rownum from syscat.indexes where owner='DB2INST1' order by indname desc fetch first 100 rows only) where rownum < 20 and rownum >= 15

DB2INST1 SQL 100805143603630 DB2INST1 15
DB2INST1 SQL100805143558190 DB2INST1 16
DB2INST1 SQL100805143558150 DB2INST1 17
DB2INST1 SQL100805143558100 DB2INST1 18
DB2INST1 SQL100805143557870 DB2INST1 19