SELECT COUNT(*), CAST(CreationDate AS Date) AS Day FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

SELECT

COUNT(*),
CAST(CreationDate AS Date) AS Day

FROM Comments 

WHERE CreationDate > DATEADD(dd, -90, GETDATE())

GROUP BY CAST(CreationDate AS Date)

ORDER BY CAST(CreationDate AS Date) DESC

Enter Parameters

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