DECLARE @PageNumber INT = 6 DECLARE @RowsCountPerPage INT = 10 SELECT BusinessEntityID , FirstName , LastName FROM Person.Person ORDER BY BusinessEntityID OFFSET ( @PageNumber - 1 ) * @RowsCountPerPage ROWS FETCH NEXT @RowsCountPerPage ROWS ONLY
原文：http://www.cnblogs.com/KingUp/p/5729469.html