0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  p.Score
  ,p.Id as [Post Link]
  ,u.DisplayName as [User Link]
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

fork query

edited jan 10 22 Robotnik.

created dec 31 21 Fredy31