34,576
社区成员
发帖
与我相关
我的任务
分享
select parent_id,count(1) as qty from user
group by parent_id
order by count(1) desc
select parent_id,count(1) as qty from user
group by parent_id
order by count(1) desc
SELECT
A.parent_id,B.user_name,COUNT(*) AS rowcnt
FROM [user] AS A
JOIN [user] AS B
ON A.parent_id = B.user_id
GROUP BY A.parent_id,B.user_name
ORDER BY COUNT(*) DESC;