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
More Related Contents:
- Using LIMIT within GROUP BY to get N results per group?
- Error related to only_full_group_by when executing a query in MySql
- MySQL Query GROUP BY day / month / year
- Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
- Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
- Grouping into interval of 5 minutes within a time range
- Retrieving the last record in each group – MySQL
- What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
- Mysql query to dynamically convert rows to columns
- MySQL “Group By” and “Order By”
- SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
- Group mysql query by 15 min intervals
- In SQL, how to select the top 2 rows for each group
- SQL Query to get column values that correspond with MAX value of another column?
- Is it possible to GROUP BY multiple columns using MySQL?
- Using Count to find the number of occurrences
- What does SQL clause “GROUP BY 1” mean?
- Using ORDER BY and GROUP BY together
- MySQL: How do I join same table multiple times?
- GROUP BY – do not group NULL
- MySQL GROUP BY DateTime +/- 3 seconds
- MySQL Group By Hours
- mysql count group by having
- SQL query with avg and group by
- SQL Query needed for fetch value from Two identical table but not fully identical table
- How to reset AUTO_INCREMENT in MySQL
- MySQL Like multiple values
- MySQL add days to a date
- MySQL query, MAX() + GROUP BY
- ALTER table – adding AUTOINCREMENT in MySQL