MySQL Group By and Sum total value of other column
I have 2 columns like this:
+----------+--------+
| 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'
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
It should be grave accent symbol not single quote:
SELECT word, SUM( amount )
FROM Data
GROUP BY `word`;
Output:
word SUM(amount)
dog 6
Elephant 2
SELECT word, SUM(amount) FROM Data Group By word;