Posts per day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT
 cast(Posts.CreationDate as date) AS Date,
  COUNT(Posts.Id) AS PostsCount
FROM 
  Posts
WHERE
    Posts.PostTypeId=1
GROUP BY
 cast(Posts.CreationDate  as date)
 ORDER BY cast(Posts.CreationDate as date)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached