0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

-- Accepted answers

SELECT PQ.id
-- , PQ.AcceptedAnswerId
, PQ.Title AS QuestionId
, PA.id
-- , PA.PostTypeId
, PA.Score
-- , IsAccepted = CASE PA.id WHEN PQ.AcceptedAnswerId THEN 'yes' ELSE 'no' END
, PL.Score AS [Accepted Score]
FROM posts PQ
INNER JOIN posts PA ON PA.ParentId=PQ.id
INNER JOIN posts PL ON PL.Id=PQ.AcceptedAnswerId

WHERE PL.Score < PA.Score

fork query

created feb 22 11 david.friedland