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
原文地址:https://www.cnblogs.com/beast-king/p/4531981.html