users who joined on/after the date you did, ranked by reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

declare @joindate datetime = 
  (select creationdate from users where id = ##UserID##);

select 
  rank() over ( order by reputation desc) as Rank,
  id as [User Link],
  Reputation,
  creationdate as [Dated Joined],
  lastaccessdate as [Last Activity],
  UpVotes,
  DownVotes,
  case when id = ##UserID## then '<------' else '' end as you
from users
where creationdate >= @joindate
order by reputation desc



-- Enter a numeric user id:

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results