DB2里面如何进行快速分页?就像mysql的limit之类的
从百度知道里看到的,记录下来以防忘记了只查询前10行 fetch first 10 rows onlySELECTSALE_DATE,SUM(SALE_MONEY) AS SUM_MONEYFROMSALE_REPORTGROUP BYSALE_DATEORDER BYSUM(SALE_MONEY) DESCfetch first 10 rows only;查
·
从百度知道里看到的,记录下来以防忘记了
只查询前10行
fetch first 10 rows only
SELECT
SALE_DATE,
SUM(SALE_MONEY) AS SUM_MONEY
FROM
SALE_REPORT
GROUP BY
SALE_DATE
ORDER BY
SUM(SALE_MONEY) DESC
fetch 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_REPORT
GROUP BY
SALE_DATE
ORDER BY
SALE_DATE DESC
fetch first 20 rows only
) AS top20
ORDER BY
top20.SALE_DATE ASC
fetch first 10 rows only;
更多推荐
已为社区贡献1条内容
所有评论(0)