PIVOT Table 統計每月生日人數

SQL：

1 2 3 4 5 6 7 8 9 10 11 12 13

SELECT * FROM ( SELECT DATEPART(MONTH,[Birthday]) AS [月份], count(DATEPART(MONTH,[Birthday])) AS 人數 FROM [Employees] GROUP BY DATEPART(MONTH,[Birthday]) ) AS Layer1 PIVOT( MAX(人數) FOR 月份 IN ([01], [02], [03], [04], [05], [06], [07], [08], [09], [10], [11], [12]) ) AS PivotTable

執行結果：

01	02	03	04	05	06	07	08	09	10	11	12
11	3	11	8	10	10	9	18	10	11	16	10