Comments Outscoring Their Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Comments with a score higher than the score of the post they were made on.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
  P.Id AS [Post Link],
  P.Score AS [Post Score],
  C.Id AS [Comment Link],
  C.Score AS [Comment Score]
FROM Posts AS P
INNER JOIN Comments AS C
  ON P.Id = C.PostId
WHERE C.Score > P.Score
  AND C.Score > 0
ORDER BY
  C.Score DESC,
  P.Score DESC,
  C.CreationDate DESC

Enter Parameters

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