DECLARE @PageNumber INT = 6DECLARE @RowsCountPerPage INT = 10SELECT BusinessEntityID , FirstName , LastNameFROM Person.PersonORDER BY BusinessEntityID OFFSET ( @PageNumber - 1 ) * @RowsCountPerPage ROWS FETCH NEXT @RowsCountPerPage ROWS ONLY
本文共 316 字，大约阅读时间需要 1 分钟。
DECLARE @PageNumber INT = 6DECLARE @RowsCountPerPage INT = 10SELECT BusinessEntityID , FirstName , LastNameFROM Person.PersonORDER BY BusinessEntityID OFFSET ( @PageNumber - 1 ) * @RowsCountPerPage ROWS FETCH NEXT @RowsCountPerPage ROWS ONLY
转载于:https://www.cnblogs.com/KingUp/p/5729469.html