magic_agate 发表于 2013-1-25 21:31:37

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>;
页: [1]
查看完整版本: db2最简单的分页