0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT YEAR(CreationDate) AS Yr, MONTH(CreationDate) AS Mo, SUM(1) AS Posts
FROM dbo.Posts
GROUP BY YEAR(CreationDate), MONTH(CreationDate)
ORDER BY 1 DESC, 2 DESC;

fork query

created nov 19 Brent Ozar