Posts Per Year

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

SELECT yoyo, SUM(coco1) AS coco FROM (
SELECT YEAR(DateAdded) AS yoyo, COUNT(*) AS coco1 FROM Table_Name GROUP BY DateAdded
) AS derivedtbl_1
GROUP BY yoyo
ORDER BY yoyo DESC

Views 229 Downloads 83

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

ANmarAmdeen
324
Date+Time SQL
Revisions

v1.0