CODEWITHSUNDEEP
mysqlsqldatabase
Angelo Tan
Angelo Tan

Reputation: 321

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

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.

Upvotes: 15

Views: 17060

Answers (2)

Haroon Matin
Haroon Matin

Reputation: 1

As I reviewed your question, I summarized it by one simple answer:

SELECT DISTINCT(ID), SUM(PRICE) 
FROM TABLE_NAME
GROUP BY ID;

Upvotes: -1

Martin Smith
Martin Smith

Reputation: 453028

You need GROUP BY and SUM

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

Upvotes: 24

Related Questions