2

Please login or register to vote for this query.

(click on this box to dismiss)

This Query returns the top 100 people near the input location clone of http://data.stackexchange.com/stackoverflow/s/2090/top-100-people-near-me

Q&A about the site for people organizing, marketing or licensing open source development projects

-- Top 100 People Near Me (ordered by reputation)
-- This Query returns the top 100 people near the input location
-- clone of http://data.stackexchange.com/stackoverflow/s/2090/top-100-people-near-me

select top 100
       u.id as [User ID],
       u.displayname as [User Name],
       u.reputation as [User Rep]
from users u
where upper(u.location) like upper('%' + ##YourLocation:string## + '%') -- uppercase location
order by u.reputation desc

fork query

created nov 16 11 burpenator