Score of a post over time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
  CreationDate,
  Sum(CASE WHEN VoteTypeId = 2 THEN 1 ELSE -1 END) OVER(ORDER BY Id)
FROM Votes
WHERE VoteTypeId IN (2,3) -- upvote, downvote
  AND PostId = ##postId##
ORDER BY CreationDate

Enter Parameters

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