Questions with No accepted answer where I have the highest score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached