SELECT ID,Name,Age,Addr,Tel,COUNT(1) OVER() AS total
FROM dbo.Student
WHERE Age>22
ORDER BY id DESC
OFFSET 2 ROW FETCH NEXT 2 ROWS ONLY
转载于:https://www.cnblogs.com/kaikaichao/p/5749250.html
SELECT ID,Name,Age,Addr,Tel,COUNT(1) OVER() AS total
FROM dbo.Student
WHERE Age>22
ORDER BY id DESC
OFFSET 2 ROW FETCH NEXT 2 ROWS ONLY
转载于:https://www.cnblogs.com/kaikaichao/p/5749250.html