GROUP BY - Jon Skeet's posts by month


Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

SELECT MONTH(CreationDate) AS CreationDateMonth, COUNT(*) AS PostsThisMonth
  FROM dbo.Users
  GROUP BY MONTH(CreationDate)
  ORDER BY MONTH(CreationDate);

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results