排序时候,如果排序字段不是唯一字段,两次查询数据顺序会不一直,导致一条记录出现在多页
插件生成sql:
WITH selectTemp AS (
SELECT
TOP 100 PERCENT ROW_NUMBER ( ) OVER ( ORDER BY 排序字段) AS __row_number__,
*
FROM
表
WHERE
1 = 1
ORDER BY
排序字段
)
SELECT * FROM selectTemp WHERE __row_number__ BETWEEN 701 AND 800 ORDER BY __row_number__