Languages
[Edit]
EN

MySql - group rows by months

2 points
Created by:
Kate_C
20290

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
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - friendly IT community for everyone.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join