zhuce 发表于 2016-11-16 08:11: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最简单的分页