sql server2012+版本新分页写法
发布于 2021-08-09 SQL
select [ProjectID],[ProjectName] from [dbo].[Project] order by [ProjectID] asc OFFSET (10/*从哪条开始*/) ROW FETCH NEXT 10/*获取多少条*/ rows only
select [ProjectID],[ProjectName] from [dbo].[Project] order by [ProjectID] asc OFFSET (10/*从哪条开始*/) ROW FETCH NEXT 10/*获取多少条*/ rows only