Best of the Year! (Answer)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  p.Score
  ,p.Id as [Post Link]
  ,u.DisplayName
FROM Posts p
  INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE 
  p.CreationDate > '2021-01-01T00:00:00.000'
  AND p.PostTypeId = 2
ORDER BY Score DESC

Enter Parameters

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