Bedingte Summenbildung in MySQL

[Matthias Apsel]

Hallo Rolf B,

SELECT SUM(Case PF WHEN 'Rot'  THEN DS ELSE 0 END CASE) as Rot, 
       SUM(Case PF WHEN 'Grün' THEN DS ELSE 0 END CASE) as Gruen,
       SUM(Case PF WHEN 'Blau' THEN DS ELSE 0 END CASE) as Blau 
FROM table

Die MySQL-Syntax sieht kein schließendes CASE vor. Also so:

SELECT SUM(Case PF WHEN 'Rot'  THEN DS ELSE 0 END) as Rot, 
       SUM(Case PF WHEN 'Grün' THEN DS ELSE 0 END) as Gruen,
       SUM(Case PF WHEN 'Blau' THEN DS ELSE 0 END) as Blau 
FROM table

Bis demnächst
Matthias