db2最简单的分页

magic_agate

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