Consolidate and Add Values

[Audrey W.]

I am trying to consolidate rows that have some redundant rows Account (VARCHAR) and at the same time add Worth (INT) values in corresponding rows. My end result I want is to have one row per Account with the amounts for all worth combined together. If anyone has any direction that would be much appreciated!!!

 

Account	Name	Worth
ABD	Bob's	1.25
SDG	Susan's	22.5
DHB	Bill's	15.26
DHB	Bill's Shoes	500
DHB	Gerald	15.2
GTS	Marge	45.6
GGG	Homer	45.68
GGG	Homer	2
After:
Account	Name	Worth
ABD	Bob's	1.25
SDG	Susan's	22.5
DHB	Bill's	530.46
GTS	Marge	45.6
GGG	Homer	47.68

[shaili_shah]

Hii, i've written the query :

select Account, Sum(Worth) as Worth from Table_Name group by Account;

I hope this'll help you.

Thanks!