T-SQL---分页语句

SELECT
      TOP PageSize *
 FROM
     (
        SELECT
             ROW_NUMBER () OVER (ORDER BY id ASC) RowNumber ,*
        FROM
             student
     ) A
 WHERE     A.RowNumber > (PageNo - 1) * PageSize