Query numbers of records created by day/month in SQL Server

1SELECT 
2    CAST([Created] AS DATE) AS [Date],
3    COUNT(*) AS [TotalCount]
4FROM [MyTable]
5WHERE [Created] >= '2024-01-01' 
6  AND [Created] < '2025-01-01'
7GROUP BY CAST([Created] AS DATE)
8ORDER BY [TotalCount] DESC;
Copy

1SELECT 
2    SUM(CASE WHEN [Created] >= '2024-01-01' AND [Created] < '2024-02-01' THEN 1 ELSE 0 END) AS [Jan],
3    SUM(CASE WHEN [Created] >= '2024-02-01' AND [Created] < '2024-03-01' THEN 1 ELSE 0 END) AS [Feb],
4    SUM(CASE WHEN [Created] >= '2024-03-01' AND [Created] < '2024-04-01' THEN 1 ELSE 0 END) AS [Mar],
5    SUM(CASE WHEN [Created] >= '2024-04-01' AND [Created] < '2024-05-01' THEN 1 ELSE 0 END) AS [Apr],
6    SUM(CASE WHEN [Created] >= '2024-05-01' AND [Created] < '2024-06-01' THEN 1 ELSE 0 END) AS [May],
7    SUM(CASE WHEN [Created] >= '2024-06-01' AND [Created] < '2024-07-01' THEN 1 ELSE 0 END) AS [Jun],
8    SUM(CASE WHEN [Created] >= '2024-07-01' AND [Created] < '2024-08-01' THEN 1 ELSE 0 END) AS [Jul],
9    SUM(CASE WHEN [Created] >= '2024-08-01' AND [Created] < '2024-09-01' THEN 1 ELSE 0 END) AS [Aug],
10    SUM(CASE WHEN [Created] >= '2024-09-01' AND [Created] < '2024-10-01' THEN 1 ELSE 0 END) AS [Sep],
11    SUM(CASE WHEN [Created] >= '2024-10-01' AND [Created] < '2024-11-01' THEN 1 ELSE 0 END) AS [Oct],
12    SUM(CASE WHEN [Created] >= '2024-11-01' AND [Created] < '2024-12-01' THEN 1 ELSE 0 END) AS [Nov],
13    SUM(CASE WHEN [Created] >= '2024-12-01' AND [Created] < '2025-01-01' THEN 1 ELSE 0 END) AS [Dec]
14FROM [MyTable]
15WHERE [Condition] = true;
Copy