/SQL/How to group by month using sql server

How to group by month using sql server

SELECT DATEPART(Year, PaymentDate) Year, DATEPART(Month, PaymentDate) Month, SUM(Amount) [TotalAmount]
FROM Payments
GROUP BY DATEPART(Year, PaymentDate), DATEPART(Month, PaymentDate)
ORDER BY Year, Month

Source: stackoverflow.com

Similar codes

10 votes198 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote242 views1 answer
Mysql remove last character
SQL
2 votes179 views1 answer
Rails execute sql
SQL
8 votes263 views2 answers
Change name of colum in sql table
SQL
0 vote225 views1 answer
Set mysql socket file docker windows
SQL
0 vote148 views1 answer
Connection error in mysql workbench
SQL
0 vote181 views1 answer
How to select all fieldsin a soql query
SQL
8 votes171 views3 answers
Duplicate entry
SQL
24 votes186 views5 answers
Sql server insert into select
SQL
0 vote212 views1 answer
Oracle step procedure
SQL