Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)
Q&A for professionals and students of engineering
-- Top Users by Country -- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew) SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], DisplayName, Id AS [User Link], Reputation tt --,* FROM Users WHERE LOWER(Location) LIKE LOWER('%##CountryName##%') --id=1998051 ORDER BY Reputation DESC;