Q&A about the site for professional linguists and others with an interest in linguistic research and theory
-- Find Stack Overflow Top 10 User in the Country
SELECT TOP 10 RankNo, [User Link], Reputation, DisplayName, Location
SELECT Id [User Link], Reputation, DisplayName, Location,
DENSE_RANK() OVER (ORDER BY Reputation DESC) RankNo
WHERE Location like '%##Location##%'
WHERE RankNo <= 10
ORDER BY RankNo