7

Please login or register to vote for this query.

(click on this box to dismiss)

What is my overall rank compared to other users and which user page am I on.

Q&A for programming puzzle enthusiasts and code golfers

-- How do I Rank Compared to Other Users
-- What is my overall rank compared to other users and which user page am I on.

declare @UserId int = ##UserId##

select (count(*) + 1) as Rank, ((count(*) / 35) + 1) 'User Page',
       (select reputation from users
        where id = @UserId) Reputation
from users
where reputation > (select u.reputation from users u where u.id = @UserId)

fork query

created jul 9 10 krock