日常工作中,经常用到分页,记录一下以备方便工作,也给大家分享一下,可以参考,也许你能用到
SELECT
TOP ${PAGE_SIZE}
CUSTOMER_ID,
GRP
FROM
(
SELECT ROW_NUMBER () OVER ( ORDER BY CUSTOMER_ID ASC ) PAGE_ROW_NUMBER, CUSTOMER_ID, GRP FROM (
SELECT DISTINCT CUSTOMER_ID,GRP FROM HSGD_SR_STORE_RELATION
) AS PAGE_TABLE_ALIAS
) AS PAGE_TABLE_ALIAS
WHERE
PAGE_ROW_NUMBER > ${ (PAGE_NUM- 1) * PAGE_SIZE }
ORDER BY
PAGE_ROW_NUMBER