How many Posts per day? (Both questions and answers)

1

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( DAY, DATEDIFF( DAY, 0, p.CreationDate ), 0 )   AS [Date]
            , COUNT (p.PostTypeId)                                  AS [Posts per day]
FROM        Posts p
GROUP BY    DATEADD( DAY, DATEDIFF( DAY, 0, p.CreationDate ), 0 )
ORDER BY    DATEADD( DAY, DATEDIFF( DAY, 0, p.CreationDate ), 0 )

Enter Parameters

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