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

[Alan Campin <alan0307d@xxxxxxxxx>]

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.