MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

RE: SQL SUM(fieldname) - can I use CASE??



fixed

Are you wanting a sum by item-group?

CASE statement should do it for you.

SELECT item-group,
SUM(CASE item-group WHEN 'A' THEN fieldname
WHEN 'B' THEN fieldname * -1
END)
FROM filename
GROUP BY item-group

Any groups other than "A" or "B"? You could add an ELSE clause to the CASE
statement.

Have fun!


-----Original Message-----

Can I sum a fieldname using the CASE stmt as follows:

when the item-group = 'A', sum as is;
when the item-group = 'B', multiply by -1 and then sum?


How is this best accomplished?

Must I have two select stmts, one for the 'A' group and another for the 'B'
group?

Or can I somehow use the CASE stmt to sum each case differently?

Or a better way?

Thanks






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact