Find users by location

5

Please login or register to vote for this query.

(click on this box to dismiss)

Shows all the users for the supplied location parameter, sorted by reputation. The Location parameter is an SQL wild card. For example: %Africa%

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results