Top 100 People Near Me (ordered by reputation)

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

Stack Overflow

Q&A for programmers

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached