34,576
社区成员
发帖
与我相关
我的任务
分享
WITH t AS (
SELECT
rownum=ROW_NUMBER()OVER(ORDER BY InfoId)
,[InfoId]
,[Abstract]
FROM Bull as a
)
select
t.[InfoId]
,t.[Abstract]
,b.rownum as TotalRow
from t cross join (select top 1 rownum from t order by t.rownum desc) as b
WHERE t.rownum BETWEEN @PageRow*(@PageNo-1)+1
AND @PageRow*@PageNo
你在加一列
该列符合查询条件的总数
不就行啦