SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY Id ASC) AS rowid,* FROM UserInfo)t WHERE t.rowid > @min AND t.rowid <= max
pageIndex当前页数
pageSize每页几个
@min=（pageIndex-1）*pageSize
@max=pageIndex*pageSize
本文共 252 字，大约阅读时间需要 1 分钟。
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY Id ASC) AS rowid,* FROM UserInfo)t WHERE t.rowid > @min AND t.rowid <= max
pageIndex当前页数
pageSize每页几个
@min=（pageIndex-1）*pageSize
@max=pageIndex*pageSize
转载于:https://www.cnblogs.com/sanday/p/8526566.html