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 b.Date),
  u.Id,
  u.DisplayName,
  b.Date
FROM Badges b
INNER JOIN users u
  ON u.Id = b.UserId
WHERE
  b.name = N'python'
  --AND u.Id = 2203084
  AND b.Class = 1
ORDER BY b.Date

fork query

edited jan 25 16 jon.doe12636

created dec 29 15 anonymous