Mysql sum with group by

-- Sum Columns only show up in SELECT statement 
-- All other columns must be in both
SELECT categories_column, SUM(units_column) AS total_units
FROM schema.table
GROUP BY categories_column;

Similar codes

4 votes337 views2 answers
Oracle last day of month
SQL
21 votes353 views1 answer
SQL cheat sheet pdf
SQL
0 vote358 views4 answers
Sql rownum
SQL
0 vote380 views1 answer
Use mysql in java program
SQL
0 vote360 views1 answer
Sql filter rows with condition
SQL
0 vote379 views1 answer
Having all mysql
SQL
0 vote331 views1 answer
Sql gap missing values
SQL
0 vote353 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote345 views1 answer
Mysql min value row
SQL
5 votes401 views1 answer
Mysql where one year ago
SQL