MaxComments for a Post

0

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 MAX(P.CommentCount) MaxCommentCountForAPost
--FROM Posts As P;

SELECT TOP 3 COUNT(C.PostId) CommentCountForAPost, C.PostId
FROM Comments AS C
GROUP BY C.PostId;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results