Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

SELECT p.PostTypeId, max(c.Score) as HighestScoredComment 
From Posts as p
Inner join 
Comments as c 
on p.Score= c.Score
Group by p.PostTypeId
ORDER by HighestScoredComment desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results