SQL-Abfrage - mehrfach-count(*) ?

[uwi1961]

SQL-Code:

select Cast( sum(
    case when s_sqlserver='S08 SQL Server 2005 (1 Proz-Lizenz) Standard' then 1
         when s_sqlserver='S09 SQL Server 2005 (2 Proz-Lizenz) Standard' then 2
         when s_sqlserver='S10 SQL Server 2005 (4 Proz-Lizenz) Standard' then 4
    else 0
    end
) As integer) ) As "count(*)"
from pc

:gruebel: bringt leider Fehler : "...for the right syntax to use near 'integer) ) As "count(*)" from pc' at line 7

Gruß Uwe

[mkinzler]

Muss wohl

SQL-Code:

as Signed

heissen
http://dev.mysql.com/doc/refman/5.1/...functions.html

[uwi1961]

:thumb: :thumb: :thumb:

Besten Dank an alle ... und ein schönes Wochenende - es funktioniert bestens.

hier nochmal komplett:

SQL-Code:

select Cast( sum(
    case when s_sqlserver='S08 SQL Server 2005 (1 Proz-Lizenz) Standard' then 1
         when s_sqlserver='S09 SQL Server 2005 (2 Proz-Lizenz) Standard' then 2
         when s_sqlserver='S10 SQL Server 2005 (4 Proz-Lizenz) Standard' then 4
    else 0
    end
) As signed) As "count(*)"
from pc