Rankng

0

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

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