mysql - mysql中的总金额

Question

我有这个请求，但效果不佳。

select date_format(date, "%Y-%m-%d") as month,
                                           sum(value) as total
                                    from :table_orders_sales_commission
                                    where date_sub(now(), interval 12 month) <= date
                                    group by month

结果是:

2017-04-02 4.6440
2017-04-03 2.6200

如何求一个月的总和(4.644+2.62)？

Answer 1

使用 MONTH 函数并将其用作分组依据

select MONTH(date_format(date, "%Y-%m-%d")) as month,
sum(value) as total
from :table_orders_sales_commission
where date_sub(now(), interval 12 month) <= date
group by MONTH(date_format(date, "%Y-%m-%d"))