Re: SQL Conditional SUM()

[Charles Wilt <charles.wilt@xxxxxxxxx>]

On Wed, Jan 11, 2017 at 9:09 AM, Manuel Chaviano <manny@xxxxxxxxxxxx> wrote:

> 1) First try:
>
>      select
>          case when QUA=1 then sum(AMT) else 0 end A1,
>          case when QUA=2 then sum(AMT) else 0 end A2
>        from Q
>        group by QUA
>
>  3....+....4....+....5....+....6....+....7....+....8....+.
>            A1                                          A2
>        102.98                                         .00
>           .00                                       11.32
>  ********  End of data  ********
>
> You get two rows. Not so good.


​You've got SUM in the wrong place, if you do it like my original post shows
select
         sum(case when QUA=1 then AMT else 0 end) as A1,
         sum(case when QUA=2 then AMT else 0 end) as A2
       from Q

You only get one row..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+.
                                       A1
       A2
                                   102.98
    11.32

Charles​