SQL ROW_NUMBER() OVER 分页

 WITH temptbl AS (
            SELECT ROW_NUMBER() OVER (ORDER BY A.Number DESC) AS Row, *
            FROM A (NOLOCK)
            WHERE 条件)
            SELECT * FROM temptbl WHERE Row BETWEEN 开始 and 结束