Questions with No accepted answer where I have the highest score

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

-- Questions with No accepted answer where I have the highest score
-- 
SELECT a1.*
FROM Posts a1
INNER JOIN Posts q ON q.ID = a1.ParentID

WHERE a1.OwnerUserID= ##UserID## AND q.AcceptedAnswerID IS NULL
    AND (SELECT MAX(p.Score) FROM Posts p WHERE p.ParentID=q.ID AND p.ID<>a1.ID) < a1.Score

created jul 20 11