Re: SQL GROUP BY and COUNT

[Carel <coteijgeler@xxxxxxxxx>]

COALESCE perhaps?

Regards,

carel Teijgeler


Op 2-3-2017 om 21:25 schreef dlclark@xxxxxxxxxxxxxxxx:
>          I have an SQL view which is a right join where the left table has
> 722 rows and the right table has 854 rows.  I therefore expect 132 null
> rows to represent the left table.  Yet, when I run the following SQL
> statement it only counts 722 rows.  Why doesn't it count the 132 null
> rows?  And is there a way I can change this statement to count those rows
> along with the other rows?  Thanks.
>
> Select LifoYn, count(LifoYn) as Count
>    from SHR460T.IMLFCMPV02
>   Group by LifoYn
>   Order by LifoYn;
>
> LIFOYN   COUNT
> N          229
> Y          493
> -            0
> ------ -------
>             722
>         -   854
>         -------
>             132
>
> Sincerely,
>
> Dave Clark