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

    Unanswered: Consolidation Query

    Just need to consolidate data in SQL

    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!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Use SUM and GROUP BY as in this simple example:

    SELECT deptno, SUM(sal) AS deptsal
    FROM emp
    GROUP BY deptno;

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please don't cross-post

    http://www.dbforums.com/t1005683.html
    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
  •