ROW_NUMBER()使用
select ROW_NUMBER() over(order by sort) as idSort, * from dbo.Class
ROW_NUMBER()分页
select * from
(select ROW_NUMBER() over(order by sort) as idSort, * from dbo.Class) as t
where t.idSort between 当前页*每页记录 and 当前页*每页记录+每页记录
ROW_NUMBER()使用
select ROW_NUMBER() over(order by sort) as idSort, * from dbo.Class
ROW_NUMBER()分页
select * from
(select ROW_NUMBER() over(order by sort) as idSort, * from dbo.Class) as t
where t.idSort between 当前页*每页记录 and 当前页*每页记录+每页记录