SQL Query with Sum and Group By

Question

I have a table similar to the example below.

Field1 Field2
Chris   100
Chris   200
John    50
Maria   250
John    80

I want to achieve the result shown below.

Chris 300
John  130
Maria 250

I've already achieved this by using 2 separate sql statements. I'm wondering if it can be achieved in a single SQL statement to speed up querying. Thank you very much.

In what part do you need a COUNT or UNION (as in the title)? That is a SUM only. Maybe add a little more info on what you are trying to do. — Filipe Silva
– Filipe Silva, Commented Dec 11, 2013 at 16:18

Hedinn · Accepted Answer · 2013-12-11 16:18:07Z

2

Group by the field you want to sum over and then use sum on the column you want to sum

SELECT Field1, SUM(Field2) as Field2
FROM Mytable
GROUP BY Field1

answered Dec 11, 2013 at 16:18

Hedinn

8644 silver badges7 bronze badges

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

Comments

tmandry · Accepted Answer · 2013-12-11 16:18:39Z

1

Should be able with:

SELECT field1, SUM(field2) FROM table GROUP BY field1

shouldn't it?

answered Dec 11, 2013 at 16:18

tmandry

3744 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQL Query with Sum and Group By

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related