select * from(select *,row_number()over(ORDER BY table.columnName
) as num from table) as t WHERE t.num>=1 and t.num<=10
Sql Server百万级数据分页分段查询语句
最新推荐文章于 2023-08-21 19:57:27 发布
select * from(select *,row_number()over(ORDER BY table.columnName
) as num from table) as t WHERE t.num>=1 and t.num<=10