DB2的分页语句

2014-11-24 02:47:03 · 作者: · 浏览: 3

DB2的分页语句
SELECT * FROM www.2cto.com
2 (
3 SELECT B.*, ROWNUMBER() OVER() AS RN FROM
4
(
5 SELECT * FROM
6 ) AS B
7 )AS A WHERE A.RN BETWEEN AND ;