Re: SQL Conditional SUM()

[Charles Wilt <charles.wilt@xxxxxxxxx>]

SUM(CASE WHEN flag THEN col1 ELSE 0 end) AS bucket1
, SUM(CASE WHEN NOT flag THEN col1 ELSE 0 end) AS bucket2

Charles

On Wed, Jan 11, 2017 at 8:26 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

>         I need to SUM() a column into two different result buckets
> depending on a flag in another file.  I know how to GROUP, SUM, and JOIN
> what I need but I'm not sure about getting a single input column to sum
> into two different output columns.  Can anybody give me a hint, please?
> Thanks.
>
> Sincerely,
>
> Dave Clark
> --
> int.ext: 91078
> direct: (937) 531-6378
> home: (937) 751-3300
>
> Winsupply Group Services
> 3110 Kettering Boulevard
> Dayton, Ohio  45439  USA
> (937) 294-5331
>
>
>
> ************************************************************
> *********************************
> This email message and any attachments is for use only by the named
> addressee(s) and may contain confidential, privileged and/or proprietary
> information. If you have received this message in error, please
> immediately notify the sender and delete and destroy the message and all
> copies. All unauthorized direct or indirect use or disclosure of this
> message is strictly prohibited. No right to confidentiality or privilege
> is waived or lost by any error in transmission.
> ************************************************************
> *********************************
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD