0

Please login or register to vote for this query.

(click on this box to dismiss)

Top 100 users by reputation from a location

Q&A for anime and manga fans

-- Top100 Ranked Users by Location
-- Top 100 users by reputation from a location

select top 100 
   id as [User Link],
   reputation,
   row_number() over(order by reputation desc) as 'Rank'
from Users with (nolock)
where lower(location) like '%' + lower(##Location:string##) + '%'
order by reputation desc

fork query

created aug 14 11 AnswerBot