Top community members
All Wiki Articles Create Wiki Article

Welcome to Dirask IT community! ❤ 💻
We are community of people that helps each other.

If you are beginner in IT field, you are more then welcome to ask questions, it will help you to learn faster. We are here to help you.

We are always beginner in something, we just need to remember it along the way.

there are no wrong questions - Ask Question

MySql - group rows by months

0 contributions
2 points

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

 

0 contributions

Checkout latest Findings & News:

Checkout latest questions:

Checkout latest wiki articles:

Hey 👋
Would you like to know what we do?
  • Dirask is IT community, where we share coding knowledge and help each other to solve coding problems.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.
Read more