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%

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- Find users by location
-- Shows all the users for the supplied location parameter, sorted by reputation.  The parameter is a wild card.


SELECT TOP(200)
  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

view current version

edited dec 17 10

created dec 17 10 philipf