六狼论坛's Archiver
首页
›
DB2
› db2最简单的分页
magic_agate
发表于 2013-1-25 21:31:37
db2最简单的分页
SELECT * FROM ( SELECT B.*, ROWNUMBER() OVER() AS RN FROM ( SELECT * FROM <TABLE_NAME> ) AS B )AS A WHERE A.RN BETWEEN <START_NUMBER> AND <END_NUMBER>;
页:
[1]
查看完整版本:
db2最简单的分页