Group by Day Date Hour Month or Year in SQL Server

Hi makenzi.exc,

Refer following query.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

GROUP BY Day

SELECT FORMAT([OrderDate], 'dddd') [Day],
       SUM(Freight) AS Freight
FROM [Orders]
GROUP BY FORMAT([OrderDate], 'dddd')

Screenshot

GROUP BY DATE

SELECT CAST([OrderDate] AS DATE) [Day],
       SUM(Freight) AS Freight
FROM [Orders]
GROUP BY CAST([OrderDate] AS DATE)

Screenshot

GROUP BY MONTH

SELECT DATENAME(MONTH, [OrderDate]) [Month],
       SUM(Freight) AS Freight
FROM [Orders]
GROUP BY DATENAME(MONTH, [OrderDate])

Screenshot

GROUP BY YEAR

SELECT YEAR([OrderDate]) [Year],
       SUM(Freight) AS Freight
FROM [Orders]
GROUP BY YEAR([OrderDate])

Screenshot

GROUP BY HOUR

SELECT FORMAT([OrderDate], 'HH') [Hour],
       SUM(Freight) AS Freight
FROM [Orders]
GROUP BY FORMAT([OrderDate], 'HH')