Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    2

    Post Unanswered: Summing with field name

    Im trying to create a sum of a rowset, including other fields that those used in the sum.

    Consider this table:
    | Money | Person |
    ============
    | 10 | A |
    | 15 | A |
    | 20 | A |
    | 10 | B |
    | 20 | B |

    Im trying to return the following result:

    | Sum | Person |
    ===========
    | 45 | A |
    | 30 | B |

    I can't figure out how to combined the SELECT Sum(Money) statement with the SELECT Sum, Person statement. Anyone have a good idea how to do this ?

    NB: Im using the SQL dialect supplied by MSSQL server

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Use SUM in combination with GROUP BY

    Hello,

    what about

    SELECT SUM(money), person
    FROM table
    GROUP BY person

    Hope that help ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  3. #3
    Join Date
    May 2003
    Posts
    2

    Talking

    Thanks, alligatorsql.com.

    That was exactly what I was looking for !

Posting Permissions

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