MySQL: GROUP BY Day, Month and Year

COUNT(id) and GROUP BY is a good choice for doing that. In the following example, the date column is "dat".

Here is how to get the number grouped by years:

SELECT COUNT(id), YEAR(dat) FROM tab GROUP BY YEAR(dat);

Here is how to get the number grouped by months:

SELECT COUNT(id), MONTH(dat), YEAR(dat) 
FROM tab GROUP BY YEAR(dat), MONTH(dat);

And here is how to get the number grouped by days:

SELECT COUNT(id), DAY(dat), MONTH(dat), YEAR(dat) 
FROM tab GROUP BY YEAR(dat), MONTH(dat), DAY(dat);

You can read more about that in this tutorial.
Last update on 2023-01-18 | Created on 2016-04-24

After group by using month, year and day the data shows as vertical list data...

Is it possible we can transform into horizontal list data?
2017-12-20 at 10:13