db2最简略的分页

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