select top 10 users.displayname, count(*) count from post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 10 users.displayname, count(*) count 
from posts inner join Users on Posts.OwnerUserId = Users.Id
where posttypeid = 1
group by posts.owneruserid, Users.displayname
order by count desc

Enter Parameters

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