0

Please login or register to vote for this query.

(click on this box to dismiss)

As in the title. Depends on what people type into the country description.

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

-- Are you one of the top SO-users in your country or state?
-- As in the title. Depends on what people type into the country description.

declare @MyRep int;
declare @UserId int;
SET @UserId = ##UserId##;

SELECT @MyRep = reputation
FROM users
WHERE id = @UserId

select
  ROW_NUMBER() OVER (ORDER BY reputation DESC),
  reputation,
  id as [User Link],
  location,
  age
from users
where location like '%##country##%'
AND reputation >= @MyRep
order by reputation desc

fork query

edited jul 18 12 anonymous

created sep 19 10 christophed