0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 100 users (ranked by reputation) that are located in Vancouver according to their profile information.-

Q&A for professional and amateur woodworkers

-- Top 100 users from Vancouver
-- Lists the top 100 users (ranked by reputation) that are located in Vancouver according to their profile information.-

SELECT TOP 100
   Id,
   DisplayName,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Whistler%'
ORDER BY
   reputation DESC

fork query

created apr 1 11 mu is too short