DB2里面如何进行快速分页？就像mysql的limit之类的

从百度知道里看到的，记录下来以防忘记了

只查询前10行

fetch first 10 rows only

SELECT  SALE_DATE,  SUM(SALE_MONEY) AS SUM_MONEYFROM  SALE_REPORTGROUP BY  SALE_DATEORDER BY  SUM(SALE_MONEY) DESCfetch first 10 rows only;

查询   11 - 20
(fetch first 20 rows only)       fetch first 10 rows only

SELECT  top20.*FROM  (  SELECT    SALE_DATE,    SUM(SALE_MONEY) AS SUM_MONEY  FROM    SALE_REPORTGROUP BY    SALE_DATE  ORDER BY    SALE_DATE DESC  fetch first 20 rows only  ) AS top20ORDER BY  top20.SALE_DATE ASCfetch first 10 rows only;