What are the top 5 “Post Titles” with the most comments? Include the “Title” and the record count of


Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

--select count(text) as numberofcomments, datepart(day,creationdate) as dayofweek
--from comments
--where creationdate >= '2021-11-01' and creationdate <='2021-11-07'
--group by datepart(day,creationdate)

select count(text)
from comments
where convert(date,creationdate) = '2021-11-07'-- and '2021-11-07'

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results