mysql使用列的总和来获取每组的总金额

Question

这是表订单中的数据。

有谁可以帮我做统计工作吗？

-------------------------------id  | order_amount | createtime-------------------------------1   |    10        | 15136055222   |    20        | 15136055233   |    30        | 15136055244   |    40        | 1513605525-------------------------------

This is the output what I need

------------------------------- total_income | createtime-------------------------------    10        | 1513605522    30        | 1513605523    60        | 1513605524   100        | 1513605525-------------------------------

this is my sql statement, it doesn't give me what i want.

select sum(order_amount) as total_income from order group by create time;

顺便提一句。是否可以产生输出......任何帮助对我来说都意义重大。非常感谢。

Answer 1

您可以使用:

set @amt := 0;
select @amt := @amt + order_amount as total_income, createtime
from order
order by createtime asc;