Forum

Hallo uli,

meinst Du sowas:

SELECT INR, DATUM,
SUM ( CASE WHEN TREFFER = 0 THEN 1 ELSE 0 END ) as tgleich0,
SUM ( CASE WHEN TREFFER > 0 THEN 1 ELSE 0 END ) as tgroesser0
  FROM tabelle
GROUP BY INR , DATUM