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

Just queried google

Can be easily rewritten as :

SELECT SUM(CASE WHEN Column2 = 'Some Value' THEN Column1 ELSE 0 END)
asFieldNeeded1
,

SUM(CASE WHEN Column2 = 'Some Other Value' THEN Column1 ELSE 0 END)
asFieldNeeded2,

SUM(CASE WHEN Column2 = 'Some Other Value 3' THEN Column1 ELSE 0 END)
asFieldNeeded3

FROM MyTable





On Fri, Nov 30, 2012 at 3:41 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

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




______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.