1:
select * from (select ROW_NUMBER() over(order by id) as rowid,* from tb) a where rowid between 51 and 60
2:
select top 10 * from tb where id not in (select top 50 id from tb order by id)
提取第50~60条记录(数据id不连续)
最新推荐文章于 2020-08-04 10:24:39 发布