self-accepted answer with negative score to a well received question


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.Id as [Post Link],
p.Score as QuestionScore,
a.Score as AnswerScore
FROM Posts AS p, Posts AS a
  WHERE p.PostTypeId = 1 AND
        p.AcceptedAnswerId IS NOT NULL AND
        a.Id = p.AcceptedAnswerId AND
        a.Score < 0 And
        p.Score > 0 And
        p.OwnerUserId = a.OwnerUserId
  ORDER by
     p.Score - a.Score DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results