--统计总条数
SELECT COUNT(1) FTotalCount FROM dbo.tablexxx WHERE 条件
--分页查询
WITH cte AS(
SELECT xxx,xxx,xxx
,ROW_NUMBER() OVER(ORDER BY 排序字段 DESC) AS RowNo
FROM dbo.tablexxx
WHERE 条件
)SELECT cte.*
WHERE
cte.RowNo BETWEEN (@FPageIndex-1)*@FPageSize+1 AND @FPageIndex*@FPageSize;
--@FPageIndex 页面索引,也就是说的第几页
--@FPageSize 每页显示多少条