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