计数状态类型，并把总计一行

Question

我有以下结果集

Status, Name 
0, Type0 
0, Type0 
1, Type1 
0, Type0 
2, Type2 

如何我总结的种类数量和使它看起来像

Type0,Type1,Type2 
3,1,1 

Answer 1

SELECT 
    COUNT(CASE WHEN Name='Type0' THEN 1 END) AS Type0, 
    COUNT(CASE WHEN Name='Type1' THEN 1 END) AS Type1, 
    COUNT(CASE WHEN Name='Type2' THEN 1 END) AS Type2 
FROM YourTable