0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

select top (1) with ties
 *
from
(
select
 x.DisplayName,
 x.Name as UserName,
 count(*) as NumBadges 
from
 ( 
select distinct
 u.DisplayName,
 b.Name
from
 Badges b
 inner join Users u
  on u.Id = b.UserId    
 ) x
group by
 x.DisplayName,
 x.Name
) y
order by
  y.NumBadges desc

fork query

created sep 20 11 anonymous