带分页的sql语句
时间：2021-07-01 10:21:17
帮助过：33人阅读
* 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开始)
带分页的sql语句
标签：span rownumber page 页码 top color number ted order
