0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for peer programmer code reviews

SELECT TOP 150 
ROW_NUMBER() OVER (ORDER BY Users.Reputation DESC) AS Rank,
  Users.Id as [User Link], 
  Users.Age,
  Users.Reputation as Rep
FROM Users
WHERE Users.Age <= 30
ORDER BY Rank ASC, Users.Age ASC

fork query

edited jun 11 15

created jun 11 15 anonymous