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)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

--select count(text) as numberofcomments, datepart(weekday,creationdate) as dayofweek
--from comments
--where creationdate between '2021-11-01' and '2021-11-07'
--group by datepart(weekday,creationdate)--, creationdate

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

Enter Parameters

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