0

Please login or register to vote for this query.

(click on this box to dismiss)

Show the posts that received the most upvotes in one day

Q&A for professional and enthusiast programmers

SELECT TOP 100
  v.PostId AS [Post Link],
  (DateDiff(second, Min(p.CreationDate), v.CreationDate) + 86400) / 86400 AS [Age],
  Count(*) AS [Upvotes]
FROM Votes v
LEFT JOIN Posts p ON p.Id = v.PostId
WHERE v.VoteTypeId = 2 -- upvote
GROUP BY v.PostId, v.CreationDate
ORDER BY [Upvotes] DESC

fork query

edited jun 14 12

created jun 14 12 Gilles