Newer Users with More Reputation Than Me


Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

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 as [User Link], u.Reputation, u.Reputation - me.Reputation as Difference, u.CreationDate
from users u cross join users me
where = @UserId
and u.CreationDate > me.CreationDate
and u.Reputation > me.Reputation
order by Difference desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results