Sum Question

buzmay · #1 (**permalink**) 02-01-12, 09:40

Hi,

I need help with the sum function. I have this query which works just the way I want:

Code:

 
SELECT SUM (SPLIT) FROM CC_SPLIT WHERE COMPANY = 'XXX' AND ACCOUNT ='YYY'

However I would like to do this for all the companies and accounts at the same time rather than needed to write one by one, is this possible?

Thanks in advance

MCrowley · #2 (**permalink**) 02-01-12, 09:48

Code:

select company, account, sum(split)
from cc_split
group by company, account

buzmay · #3 (**permalink**) 02-01-12, 09:53

Thanks a lot

Internet Services

Web Development

Digital Marketing

Consumer Tech