SQL Server 獲取數(shù)據(jù)的總記錄數(shù)，有兩種方式：

1.先分頁獲取數(shù)據(jù)，然后再查詢一遍數(shù)據(jù)庫獲取到總數(shù)量

2.使用count(1) over()獲取總記錄數(shù)量

SELECT
*
FROM
(
SELECT
ROW_NUMBER() OVER(ORDER BY Id DESC) rn,
COUNT(1) OVER() AS TotalCount,
Id
FROM
dbo.T_User
)a
WHERE
a.rn BETWEEN 1 AND 5