Single Post - Most Comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

--What is the most number of comments on a single post?
SELECT posts.title,count(posts.id) FROM posts
inner join comments on posts.id = comments.postid
group by posts.title
order by count(posts.id) desc

Enter Parameters

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