T-SQL---分页语句 

select * from(select (row_number() OVER (ORDER BY stud_id)) as rownum,tab.* from score As tab) As t where rownum between 2 And 6

 

posted @ 2015-05-26 22:33  框框A  阅读(171)  评论(0)  编辑  收藏  举报