0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

;With OrderedUsers As 
(Select Id, Sum(Reputation) Over( Order By Reputation Desc) As AggRep
From Users
)
Select Id As [User Link], AggRep
From OrderedUsers
Where AggRep = (Select Max(AggRep) From OrderedUsers Where AggRep < ##MaxAggRep##)

fork query

edited dec 25 16

created dec 25 16 Mark Hurd