SELECT *
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY userID ASC ) AS rownumber ,
*
FROM dbo.t_user
WHERE 1 = 1
) AS t
WHERE t.rownumber > (PageSize *(PageIndex-1))
AND t.rownumber <= (PageSize *PageIndex)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交