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开始)
带分页的sql语句
标签：span rownumber page 页码 top color number ted order
带分页的sql语句
* FROM (
SELECT ROW_NUMBER() OVER (ORDER BY UpdatedDate desc) AS RowNumber,* FROM [表名] Where (1=1) and (其他条件)
) A WHERE RowNumber > {0}*({1}-1)
SELECT ROW_NUMBER() OVER (ORDER BY UpdatedDate desc) AS RowNumber,* FROM [表名] Where (1=1) and (其他条件)
) A WHERE RowNumber > {0}*({1}-1)