Sum of Multiple rows in MySql

Question

I have data in this manner

ID       SUB       Marks    
 1      English      25
 1       Maths       22
 1      Science      15
 2      English      16
 2       Maths       20
 2      Science      12

And so on...

How would I sum all subject marks and give total marks of each ID?

For example, if I select ID=1 then it should show 62.

There are SQL manuals online if you don't actually want to buy one or take some training, e.g. w3schools.com/sql/default.asp Visit this site and then come back and ask questions if you still can't work these things out. — CashCow
– CashCow, Commented Dec 3, 2012 at 15:32

Abe Miessler · Accepted Answer · 2012-09-11 18:53:25Z

10

This should do it:

SELECT ID, SUM(Marks) as totalMarks
FROM MyTable
GROUP BY Id

answered Sep 11, 2012 at 18:53

Abe Miessler

85.7k104 gold badges324 silver badges496 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gratzy · Accepted Answer · 2012-09-11 18:52:00Z

6

select id, sum(Marks) as marks
from tablename
group by id

answered Sep 11, 2012 at 18:52

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

Comments

Ajay Pankhaniya · Accepted Answer · 2014-05-27 09:03:55Z

2

Try this... this is working...

SELECT ID, SUM(Marks) as Total
FROM Table_Name
GROUP BY ID
ORDER BY ID

answered May 27, 2014 at 9:03

Ajay Pankhaniya

895 bronze badges

Collectives™ on Stack Overflow

Sum of Multiple rows in MySql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related