java - 如何对具有相同 id 的两行求和

Question

这个问题已经有答案了:

How to SUM two fields within an SQL query (9 个回答)

已关闭 4 年前。

我的数据库下面它的表名被标记了，

请帮我编写一个代码来创建下面的另一个表

SELECT [ID] , sum([physics])
FROM [mark]
GROUP BY [ID]

Answer 1

只需添加两个字段:

SELECT [ID] , sum([physics]), sum([math]), sum([sum]) 
FROM [mark]
GROUP BY [ID]

如果您想创建一个表，请使用以下脚本:

CREATE TABLE new_table AS
SELECT [ID] , sum([physics]), sum([math]), sum([sum]) 
FROM [mark]
GROUP BY [ID]