posts per month

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Tridion developers and administrators

SELECT FORMAT(CreationDate, 'yyyy-MM') AS [month], count(*) AS [posts]
 FROM posts
 GROUP BY FORMAT(CreationDate, 'yyyy-MM')

created nov 23

anonymous

Options: Text-only results Include execution plan

Switch to main site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached