aspnet企业级开发:sql分页语句
1 select *,row_number() over(order by name) as 'row_number' from student 2 3 select top 5 * from student where id not in (select top 5 id from student)
1 select *,row_number() over(order by name) as 'row_number' from student 2 3 select top 5 * from student where id not in (select top 5 id from student)