1

Please login or register to vote for this query.

(click on this box to dismiss)

Find useres that have been members for a shorter time than me but have more reputation points.

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

-- Newer Users with More Reputation Than Me
-- Find useres that have been members for a shorter time than me
-- but have more reputation points.


declare @UserId int = ##UserId##

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

fork query

edited jan 9 13 tohecz

created jul 11 10 krock