我有两列这样的:
+----------+--------+
| 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 分组依据和其他列的总和值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!