List of users who have earned specific tag order by date acquired.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT DENSE_RANK() OVER (ORDER BY a.DATE ASC) RankNo,
       b.ID [User Link], 
       b.Reputation , 
       a.DATE
FROM   badges a
       LEFT JOIN Users b
          ON a.UserID = b.ID
WHERE  UPPER(a.NAME) = UPPER('LEGENDARY')
ORDER  BY a.Date ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results