DB2 分页查询

2015/02/12 34872

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

?
1
2
3
4
5
6
7
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>;