DB2 分页查询

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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>;