Number of users per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  DateAdd(month, DateDiff(month, 0, CreationDate), 0) As Month,
  Count(DateAdd(month, DateDiff(month, 0, CreationDate),0)) As 'Monthly Joins'
FROM
  Users
GROUP BY
  DateAdd(month, DateDiff(month, 0, CreationDate), 0)
ORDER BY
  DateAdd(month, DateDiff(month, 0, CreationDate), 0);

Enter Parameters

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