SQL Sum Query

[mlager]

I have a table that looks somthing like below... I'm trying to write a single query that takes each id, sums them up, then prints them out so it looks like the table at the bottom, any advice would be great! Thanks.

id name amt
-- ---- ---
1 John 5.00
1 John 8.00
1 John 10.00
2 Bob 0.00
2 Bob 3.00
3 Joe 6.00
3 Joe 9.00
4 Dave 8.00
4 Dave 2.00
4 Dave 2.00

id name amt
-- ---- ---
1 John 23.00
2 Bob 3.00
3 Joe 15.00
4 Dave 12.00

 

[SQLSister]

use sum function on the amt column and then group by Id and name

Questions about posting. See faq183-874

 

[bborissov]

SELECT Id, Name, SUM(Amt) AS Amt
       FROM MyTable
GROUP BY Id, Name

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[mlager]

That response makes make feel stupid, not sure why I was having a mental block on that, thanks!