MySql - group rows by months

2 points
Created by:

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

Sql example:

	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.


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


Alternative titles

  1. MySql / MariaDB - group rows by months
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.

MySQL - dates

Native Advertising
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂