MySQL Summen berechnen

[Olli73]

Ungefähr so (ungetestet):

Code:

select
  kundennummer,
  sum(case when summe < 0 then 0 else summe end case) as positiv,
  sum(case when summe > 0 then 0 else summe end case) as negativ,
  sum(summe) as gesamt
from
  tabelle
group by
  kundennummer