Consolidation Query to sum totals together to yield one row

johntravoltay2k · #1 (**permalink**) 07-27-04, 06:13

Desperately need help with this...

Basically the data is the spend information for many suppliers, I need to churn out just the supplier name along with a sum of their amounts spent/ volume.

I need to get FROM THIS:

Company Contract Amount Spent Volume

Shell Oil Shell891 10 100
Shell Oil Shell892 20 200
BP BP0001 50 1
BP BP0001 100 2

TO THIS

Company Amount Spent Volume
Shell Oil 30 300
BP 150 3

Etc

So I need a query that can add both the amount spent and volume and then remove DISTINCT company name rows. I understand the basics of SQL but sub-queries start to confuse me!

I would be eternally grateful for any help/ advice/ tips.

Many, many thanks!

John

r937 · #2 (**permalink**) 07-27-04, 07:33

subqueries are not required here

Code:

select Company 
     , sum(`Amount Spent`) as totalSpent
     , sum(Volume)         as totalVolume
  from yourtable
group
    by Company

Internet Services

Web Development

Digital Marketing

Consumer Tech