1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users, experts, and developers of the Tezos blockchain project

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:

fork query

edited mar 10

created mar 10 ashleedawg