GROUP BY - Jon Skeet's posts by month

0

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 SignUpDateMonth, COUNT(*) AS PostsThisMonth
  FROM dbo.Users
  GROUP BY MONTH(CreationDate)
  ORDER BY MONTH(CreationDate);

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results