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;
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
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;
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