一条sql 执行查询列表 返回分页数据以及总数 totalCount

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

posted @ 2016-08-08 14:45  kaikaichao  阅读(13480)  评论(1编辑  收藏  举报