sql server分页

select * from(select *,ROW_NUMBER() over(order by id)as 'userID' from UserInfo) as a where a.userID between 31 and 40

posted @ 2021-01-15 11:00  竹林听雨行  阅读(31)  评论(0)  编辑  收藏  举报