我有两个这样的专栏:
+----------+--------+
| word | amount |
+----------+--------+
| dog | 1 |
| dog | 5 |
| elephant | 2 |
+----------+--------+
我想把这些金额加起来,得到结果
+----------+--------+
| dog | 6 |
| elephant | 2 |
+----------+--------+
到目前为止,我try (但失败)的是:
SELECT word, SUM(amount) FROM `Data` Group By 'word'