CODEWITHSUNDEEP
sqlgroup-byrowfield
user1560503
user1560503

Reputation: 43

Sum values from Duplicated rows

There's my sql data:

code name total
---------------
3   Sprite 2400
17  Coke   1500
6   Dew    1000
17  Coke   3000
6   Dew    2000

But code and name has duplicated values and I want to sum total from each duplicated field. Something like this:

code name total
---------------
3   Sprite 2400
17  Coke   4500
6   Dew    3000

How could I do that in sql?

Upvotes: 2

Views: 7564

Answers (1)

darren102
darren102

Reputation: 2828

SELECT code, name, sum(total) AS total FROM table GROUP BY code, name

Upvotes: 6

Related Questions