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>;
发布时间: 2012-07-22 19:31:18 作者: rapoo
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>;