Sql Server 分页查询写法

日常工作中，经常用到分页，记录一下以备方便工作，也给大家分享一下，可以参考，也许你能用到

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