users by location (stack overflow)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- 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 to meta site
loading Hold tight while we fetch your results