Re: SQL

On Tue, 12 Nov 2002 08:45:37 +0200, "cristi" <cristi@dmhi.ct.ro>
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