Top non-community-owned Comment score

1

Please login or register to vote for this query.

(click on this box to dismiss)

Handles ties correctly

Stack Overflow

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)

Enter Parameters

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