mysql - How get the sum for every distinct value in another column?

Question

Suppose my table contains the following:

ID    price    
-------------
 1     10      
 1     10      
 2     20      
 2     20      
 3     30
 3     30

Each time through a while loop. I want to get the sum of the values on price but only once for every distinct value in ID

So given the example above, I would arrive with something like:

ID    price    
-------------
 1     20          
 2     40           
 3     60

Just to add, I may have stumble upon a post with a similar inquiry. Problem is that other post uses Oracle, I on the other hand am using MySQL.

Answer 1

You need GROUP BY and SUM

SELECT ID, 
       SUM(price) AS price
FROM YourTable
GROUP BY ID