SELECT TOP {0} * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY UpdatedDate desc) AS RowNumber,* FROM [表名] Where (1=1) and (其他条件)) A WHERE RowNumber > {0}*({1}-1)
{0}：PageSize每页条数
{1}：PageIndex当前页码(1开始)
本文共 251 字，大约阅读时间需要 1 分钟。
SELECT TOP {0} * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY UpdatedDate desc) AS RowNumber,* FROM [表名] Where (1=1) and (其他条件)) A WHERE RowNumber > {0}*({1}-1)
{0}：PageSize每页条数
{1}：PageIndex当前页码(1开始)
转载于:https://www.cnblogs.com/liaoshiqi/p/7447128.html