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