MySQL: how to sum up vaues of rows and sort the result?
I'm looking for a SQL-statement that sums up some specific values and sorts the result. To be more clear: I have a table that consists of identifiers and values:
id val ab 10 ab 12 ab 3 cd 25 cd 10 ef 2 ef 7
Here all values for ab, cd and ef have to be summed up and ordered by result so that I get the following:
cd 35 ab 25 ef 9
So is there a SQL-statement that performs that task in one go?
SELECT id, SUM(val) as total FROM your_table GROUP BY id ORDER BY total DESC;
Use group function sum:
select id, sum(val) as val from my_table group by id order by 2 desc