Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Exclamation Unanswered: Consolidation Query to sum totals together to yield one row

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    subqueries are not required here
    Code:
    select Company 
         , sum(`Amount Spent`) as totalSpent
         , sum(Volume)         as totalVolume
      from yourtable
    group
        by Company
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •