读书人

db2最简略的分页

发布时间: 2012-07-22 19:31:18 作者: rapoo

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

读书人网 >其他数据库

热点推荐