/*select top 5 Users.Reputation from Users order by Users...

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 5 Users.Reputation from Users order by Users.Reputation desc*/
select top 5 Users.Id,Users.Reputation,count(Posts.Id) from Users 
join Posts on 
Users.Id=Posts.OwnerUserId and Posts.PostTypeId=1

group by Users.Id, Users.Reputation
order by Users.Reputation desc

/*select top 5 * from Users order by Reputation DESC*/

/*order by Users.Reputation DESC*/

Enter Parameters

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