Q&A about the site for enthusiasts and scholars of mythology and folklore
-- Find Stack Overflow Top N User in the Country -- TIEs are included SELECT 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 <= ##MaximumRankNo## ORDER BY RankNo