0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

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