SQL calculating sum based on another column

Question

I have a table with the following data in it:

Account number     Amount
13                 40
34                 30
14                 30
13                 60
14                 10

I would like to know how I can write a query to return the following results

Account number     Total amount
13                 100
14                 40
34                 30

The query should calculate the sum of all of the amounts in the amount column that share the same account number.

Any help would be much appreciated!

Tim Schmelter · Accepted Answer · 2014-05-06 10:50:37Z

2

Use Group By + SUM

SELECT [Account number],
       SUM(Amount) As [Total Amount]
FROM dbo.Table1
GROUP BY [Account Number]
ORDER BY SUM(Amount) DESC

answered May 6, 2014 at 10:50

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

1 Comment

Thanks heaps for that!

TechDo · Accepted Answer · 2014-05-06 10:49:55Z

0

Please try:

select
    [Account Number],
    sum(Amount) Amount
from
    YourTable
Group by [Account Number]

answered May 6, 2014 at 10:49

TechDo

18.7k3 gold badges55 silver badges64 bronze badges