How do I Rank Compared to Other Users

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.

Ebooks

Q&A for ebook publishers and readers

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

Enter Parameters

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