Are you one of the top SO-users in your country or state?

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.

Stack Overflow

Q&A for programmers

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

SET @MyRep = 0;

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

Enter Parameters

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