Top non-community-owned Comment score

Please login or register to vote for this query.

(click on this box to dismiss)

Handles ties correctly

Q&A for programmers

-- Top non-community-owned Comment score
-- Handles ties correctly

SELECT 
PostID [Post Link], score
From
comments 
WHERE score = (select max(score) from comments WHERE PostId in (select Id From Posts Where CommunityOwnedDate Is Null))
and PostId in (select Id From Posts Where CommunityOwnedDate Is Null)

edited jun 1 12