Languages
[Edit]
EN

MySql - group rows by months

2 points
Created by:
Kate_C
19580

In this short article we would like to show how MySql group rows by months.

Sql example:

SELECT
	COUNT(`creation_time`) AS `count`,
	DATE_FORMAT(`creation_time`, '%Y-%m') AS `month`
FROM clients
GROUP BY YEAR(`creation_time`), MONTH(`creation_time`)

Note: YEAR(`creation_time`) prevents rows mixing when months come from different years.

Screenshot:

group rows by months - HeidiSQL with MySql
group rows by months - HeidiSQL with MySql

 

Native Advertising
50 000 ad impressions - 449$
🚀
Get your tech brand or product in front of software developers.
For more information contact us:
Red dot
Dirask - friendly IT community for everyone.

❤️💻 🙂

Join