Who has the most copies of one badge?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Determines the ranking of who has the most of one badge, for example Nice Question.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Who has the most copies of one badge?
-- Determines the ranking of who has the most of one badge, for example Nice Question.

DECLARE @Badge nvarchar(50) = ##BadgeName:string##

SELECT UserId as [User Link], Count(*) as Count FROM Badges WHERE Name=@Badge GROUP BY UserId ORDER BY Count DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results