Group By Year Example

SELECT YEAR(date_column) AS year, COUNT(*) AS count
FROM date_month_year_table
GROUP BY YEAR(date_column);

Output:

Explanation: This MySQL query employs the `YEAR()` function to extract the year component from the “date_column” in the “date_month_year_table” and counts the occurrences for each unique year. The result is presented with two columns: “year,” representing the numeric year value, and “count,” indicating the frequency of records for each specific year.

This query exemplifies the application of the `GROUP BY` clause in MySQL for systematically aggregating and analyzing data based on the year component of date values within the specified table.

GROUP BY clause is an essential feature for data analysis. It enables users to aggregate information based on specific criteria. To group records based on day, month, and year, we can use DAY(), MONTH(), and YEAR() functions respectively.

In this article, we will look at how to use MySQL’s GROUP BY clause to organize data based on the DAY, MONTH, and YEAR components of date data. We will start by creating a database and a table and populate it with the sample data. Then, we will use the three methods of GROUP BY: GROUP BY DAY(), GROUP BY MONTH (), and GROUP BY YEAR ().