MySQL Group By和其他列的总和 [英] MySQL Group By and Sum total value of other column

问题描述

我有2列这样的内容:

+----------+--------+
|   word   | amount |
+----------+--------+
| dog      |      1 |
| dog      |      5 |
| elephant |      2 |
+----------+--------+

我想对金额求和，以获得结果

I want to sum the amounts, to get the result

+----------+--------+
| dog      |      6 |
| elephant |      2 |
+----------+--------+

到目前为止，我已经尝试过(但失败了)的是:

What I have tried so far (and failed) is this:

SELECT word, SUM(amount) FROM `Data` Group By 'word'

推荐答案

删除WORD周围的单引号.导致列名转换为字符串.

Remove the single quote around the WORD. It causes the column name to be converted as string.

SELECT word, SUM(amount) 
FROM Data 
Group By word

这篇关于MySQL Group By和其他列的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！