Aggregation based on subcategories

[harryklein]

Hi,
I am not experienced on aggregations, and now I have a task to do it.
I hava a table like this



ID, CliendID, ContactdID, SubID, Revenue, Volume. ContractId is not unique

I would like add the aggregated(SUM) Value of Revenue-s to the Volume-field based on the ContractID.

I mean there are 3 rows in the table where ContractID="A", and the aggregated Revenue of these is 10, I need to have 10 in Volume-field in every row where Contract="A".

Thanks a lot

[Bob Fitz]

Can you give us an example of the data that you have and the result that you require

[orange]

ContractID vs ContactID? confusing.
Agree with Bob, some sample data would be helpful.
You typically aggregate on a group. What is the group involved? You would not normally show the aggregated value for individual records.

[Minty]

It would be handy to see some example data and the desired output as Bob has asked, but something like

SELECT ContractID,  Sum(Revenue) as Volume 
FROM YourTable
Group By ContractID

You should not store this value - but always calculate it.
Also is it Contract or Contact ? You have referred to both in your post.