Group BY mit Zusammenfassung

[Dejan Vu]

SQL-Code:

select Count(*)
      ,case 
         when Status = 10 then '10' 
        else 'irgendein Status' 
       end as Status
from Tabelle
Group by 
      case 
        when Status = 10 then '10' 
        else 'irgendein Status' 
      end

oder

SQL-Code:

select Count(*)
     , Status
from (
  select case 
           when Status = 10 then '10' 
           else 'irgendein Status' 
         end as Status
    from Tabelle
     ) x 
group by Status

oder von mkinzler.