34,593
社区成员
发帖
与我相关
我的任务
分享
select *
from
(
SELECT
ROW_NUMBER() OVER (ORDER BY L.BlockedDate DESC) AS RowNo,
L.UserId, UserName, UserGender, UserBirthday, BlockedDate, ReleaseDate, R.OpsCnt
FROM
Blacklist AS L
INNER JOIN
(SELECT UserId, COUNT(UserId) AS OpsCnt FROM OpsHistory GROUP BY UserId) AS R
ON L.UserId = R.UserId
) t
WHERE RowNo BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize