0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
  ROW_NUMBER() OVER(ORDER BY b1.Date ASC, b2.Date ASC), 
  b1.UserId, 
  b1.Date DateReceived, b2.Date DateReceived,
  u.DisplayName
FROM Users u, Badges b1, Badges b2
WHERE b1.name='ruby' AND b1.class=1
  AND b2.name='ruby-on-rails' AND b2.class=1
  AND u.Id=b1.UserId
  AND u.Id=b2.UserId
GROUP BY b1.Date, b2.Date, b1.UserId, u.DisplayName

fork query

edited nov 18 18 Martin.Spickermann

created jan 28 17 anonymous