How to SUM two row with the same id

Question

I have the database below its table name is marked,

please help me a code to create another table below

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

Your code is correct. Add also `sum([math]), sum([sum])` in the select list. — forpas, Sep 07 '19 at 07:44

score 0 · Answer 1 · answered Sep 07 '19 at 08:24

Just add two more fields:

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

If you want to create a table use following script:

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

1 Answers1