为你而来

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)

 

posted on 2012-09-11 00:41  为你而来  阅读(131)  评论(0编辑  收藏  举报

导航