Posts per year-month

Create summary list
If you have SQL table named Messages, with DateStamp having dates, you can then create a Posts-Per-YearMonth list as summary using SQL below
Something that I use to build a Posts-Per-YearMonth list in most of my websites

SELECT yoyo, Momo, SUM(coco1) AS coco FROM (
SELECT YEAR(DateStamp) AS yoyo, Month(DateStamp) As Momo, COUNT(*) AS coco1 FROM Messages GROUP BY DateStamp
) AS derivedtbl_1
GROUP BY yoyo, Momo
ORDER BY yoyo DESC, Momo Desc

Views 657 Downloads 222

'SQL', 'Posts_Per_Year', 'Posts-Per-Year', 'Posts', 'per', 'year', 'summary', 'list', 'select', 'Post per year', 'post per year month', 'post per month'

ANmarAmdeen
448
Attachments
Date+Time SQL
Revisions

v1.0