1

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

SELECT
  RANK() OVER (ORDER BY Id) AS No,
  SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END)
    OVER (ORDER BY Id ROWS UNBOUNDED PRECEDING) AS Ups,
  SUM(CASE WHEN VoteTypeId = 3 THEN -1 ELSE 0 END)
    OVER (ORDER BY Id ROWS UNBOUNDED PRECEDING) AS Downs,
  SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE -1 END)
    OVER (ORDER BY Id ROWS UNBOUNDED PRECEDING) AS Score
FROM Votes
WHERE
  PostId = ##PostId:int##
  AND
  VoteTypeId BETWEEN 2 AND 3

UNION ALL

SELECT 0 AS No, 0 AS Ups, 0 AS Downs, 0 AS Score

ORDER BY No;

fork query

edited jul 7

created jul 7 peterh - PLEASE DELETE THIS ACCOUNT