mysql - 如何在 mysql 中使用 group by 对列求和？

Question

------------------------------------
Item         |     Box
------------------------------------
10           |      25
------------------------------------
12           |      50
------------------------------------
3            |      25
------------------------------------
4            |      30
------------------------------------
6            |      50
------------------------------------

输出应该是

[25] => 13   , [50] => 18, [30] => 4

我正在使用以下查询，但我得到了结果

  select sum(item) as qt  from table group by box

请帮我解决我的问题

Answer 1

试试这个:

SELECT sum(item) as qt, box
FROM tablename
GROUP BY box
ORDER BY qt