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

编程技巧