Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

;with league as 
select rank() over (order by reputation desc) [ranking]
     , id
     , reputation
from users where reputation > 199
select ranking
, ranking / convert(decimal,(select count(*) from league )) *100
from league
where id = 841108

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results