Sum of Multiple rows in MySql

Question

I have data in this manner

Click to copy

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.

Answer 1

This should do it:

Click to copy

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

Answer 2

Click to copy

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

Answer 3

Try this... this is working...

Click to copy

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