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 table where whereclause order by orderstr limit start,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
|
***相关主题****************************************
iBatis自动生成的主键 返回主键 (Oracle,Sql Server,Mysql)
DB2 SQL存储过程语法官方权威指南
请教一个oracle sql查询 （谢谢回答）
Oracle SQL语法速查.chm
ORACLE与SQL Server的对比材料
