SELECT YEAR(date_col) AS year, MONTH(date_col) AS month, SUM(sum_col) AS sum_column, AVG(avg_col) AS avg_column FROM table_name GROUP BY YEAR(date_col), MONTH(date_col);
上一篇:按月分组,求和值并滚动一年。
下一篇:按月分组,使用SQL中的日期时间。