SELECT *,COUNT(1) OVER() AS TotalItemCount
FROM Positions
WHERE 1=1
ORDER BY id DESC
OFFSET 1 ROW FETCH NEXT 5 ROWS ONLY
转载于:https://www.cnblogs.com/914556495wxkj/p/7202102.html
SELECT *,COUNT(1) OVER() AS TotalItemCount
FROM Positions
WHERE 1=1
ORDER BY id DESC
OFFSET 1 ROW FETCH NEXT 5 ROWS ONLY
转载于:https://www.cnblogs.com/914556495wxkj/p/7202102.html