Lowest ranking youngsters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

SELECT TOP ##top:int?5## WITH TIES
   ROW_NUMBER() OVER (ORDER BY Users.Reputation ASC) AS Row
  ,RANK() OVER (ORDER BY Users.Reputation ASC) AS Rank
  ,Users.Id as [User Link]
  ,Users.Age
  ,Users.Reputation as Rep
FROM Users
WHERE Users.Age <= ##age:int?25## and Users.Reputation >= ##rep:int?100##
ORDER BY Rank ASC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results