首页 > 技术文章 > SQL查询总数和分页数

914556495wxkj 2017-07-18 18:40 原文

SELECT *,COUNT(1) OVER() AS TotalItemCount
FROM Positions
WHERE 1=1
ORDER BY id DESC
OFFSET 1 ROW FETCH NEXT 5 ROWS ONLY

推荐阅读