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

2 votes251 views1 answer
Sql float to int
SQL
0 vote324 views1 answer
Running percentage of total postgres
SQL
1 vote312 views2 answers
Regex starts with
SQL
0 vote302 views1 answer
Synapse sql table set pk
SQL
0 vote299 views2 answers
How to update date in oracle
SQL
0 vote265 views0 answer
SQL
1 vote308 views1 answer
Show all event schedular on mysql
SQL
0 vote299 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote302 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote292 views2 answers
Mysql order by date asc null last
SQL