[MSSQL] Erweiterte Gruppierung im View

[omata]

SQL-Code:

SELECT Name, COUNT(*) Qty, Status
FROM (SELECT id, Name, CASE WHEN status in ('A', 'B') THEN 'A' ELSE 'C' END Status
      FROM Test) x
GROUP BY name, status

Edit: oder...

SQL-Code:

SELECT Name, COUNT(*) Qty, CASE WHEN status in ('A', 'B') THEN 'A' ELSE 'C' END Status
FROM Test
GROUP BY name, CASE WHEN status in ('A', 'B') THEN 'A' ELSE 'C' END