1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

-- Questions with No accepted answer where I have the highest score
-- 
SELECT
    q.Id as [Post Link],
    a1.score
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

fork query

created oct 23 11 Oli