MySQL 分组依据和其他列的总和值 [英] MySQL Group By and Sum total value of other column

问题描述

我有两列这样的:

+----------+--------+
|   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 分组依据和其他列的总和值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！