0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

-- 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

fork query

edited mar 27 12

created mar 27 12 anonymous