Shows all the users for the supplied location parameter, sorted by reputation. The Location parameter is an SQL wild card. For example: %Africa%
Q&A for linguists, teachers and students of the Korean language
-- Find users by location -- Shows all the users for the supplied location parameter, sorted by reputation. The parameter is a wild card. SELECT TOP(100) u.Id, u.DisplayName, u.Reputation, u.WebsiteUrl, u.Age, u.LastAccessDate, u.Location FROM Users u WHERE u.Location LIKE ##Location:string## ORDER by u.Reputation DESC