SQL-Abfrage - mehrfach-count(*) ?

[nahpets]

Hallo Uwe,

hilft Dir das weiter?

SQL-Code:

select
  sum(
    case when s_sqlserver='2005-1Proz' then 1
         when s_sqlserver='2005-2Proz' then 2
         when s_sqlserver='2005-3Proz' then 3
         when s_sqlserver='2005-4Proz' then 4
    else 0
    end
  ) As Ergebnis
from pc

Stephan