0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

--Newer Users with More Reputation Than Me

--Find users that have been members for a shorter time than me but have more reputation points, ordered by difference.

declare @UserId int = ##UserId##

select u.id as [User Link], u.Reputation, u.Reputation - me.Reputation as Difference, u.CreationDate
from users u cross join users me
where me.id = @UserId
and u.CreationDate > me.CreationDate
and u.Reputation > me.Reputation
order by Difference desc

fork query

created aug 6 11 jon.doe6445