Bronze Swift Badge Ranking

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query retrieves all the bronze swift badge users and ranks them according to their bronze badge date received.

Stack Overflow

Q&A for professional and enthusiast programmers

-- This query retrieves all the bronze swift badge users and ranks them according to their bronze badge date received.

SELECT ROW_NUMBER() OVER(ORDER BY b.Date ASC), b.UserId, b.Date DateReceived, u.DisplayName
FROM Users u, Badges b
WHERE b.name='swift' and b.class=3
and u.Id=b.UserId
GROUP BY b.Date, b.UserId, u.DisplayName

Enter Parameters

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