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

0

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

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