TOP 10 Users in the Country

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

-- Find Stack Overflow Top 10 User in the Country
-- TIEs are included

SELECT TOP 10 RankNo, 
              [User Link], 
              Reputation, 
              DisplayName, 
              Location
FROM
  (
  SELECT Id [User Link], Reputation, DisplayName, Location,
         DENSE_RANK() OVER (ORDER BY Reputation DESC) RankNo
    FROM Users
    WHERE UPPER(Location) like UPPER('%##Location##%')
   ) derievedtable
WHERE RankNo <= 10
ORDER BY RankNo

Enter Parameters

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