DB2分页格式:
SELECT 字段列表 FROM (SELECT 字段列表, ROW_NUMBER() OVER() AS ROW FROM TABLE_NAME ORDER BY ROW ASC) AS TMP WHERE TMP.ROW BETWEEN xNum AND yNum
eg:
SELECT A.DEPTNUMB,A.DEPTNAME,A.DIVISION,A.LOCATION,A.MANAGER FROM
(SELECT O.DEPTNUMB,O.DEPTNAME,O.DIVISION,O.LOCATION,O.MANAGER , ROW_NUMBER() OVER() AS ROW
FROM ORG O ORDER BY ROW ASC) AS A WHERE A.ROW BETWEEN 7 AND 9