Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more
-- 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