Re: SQL

Amazing!
Brilliant solution!
You make me very  happy!

Thanks!

> wrote:
> >This is the contents of the table:
> >marca     mo
> >1            C
> >2            C
> >[...]
> >
> >I need a SQL interogation with following results:
> >marca concedii boala obligatii
> >  1         2           1        0
> >  2         1            0       0
> >  4         0            1       0
> >  5         0            0       1
>
> SELECT marca,
>        SUM(CASE mo WHEN 'C' THEN 1 ELSE 0 END) AS concedii,
>        SUM(CASE mo WHEN 'B' THEN 1 ELSE 0 END) AS boala,
>        SUM(CASE mo WHEN 'O' THEN 1 ELSE 0 END) AS obligatii
>   FROM yourtable
>  GROUP BY marca
>  ORDER BY marca;
>
> HTH.
> Servus
>  Manfred
>