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
T-SQL---分页语句
原文：http://www.cnblogs.com/beast-king/p/4531981.html
