MySQL 分组依据和其他列的总和值
我有两列这样的:
+----------+--------+
| 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
相关文章