DB2 分页

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