来自重复行的总和值 [英] Sum values from Duplicated rows

问题描述

有我的sql数据:

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

我该如何在sql中做到这一点?

How could I do that in sql?

推荐答案

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

这篇关于来自重复行的总和值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！