/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

2 votes102 views1 answer
Mysql admin u root p password change password
SQL
12 votes154 views4 answers
Mysql version
SQL
0 vote136 views2 answers
Mysql slave status
SQL
1 vote148 views1 answer
Window function mysql
SQL
8 votes179 views1 answer
See all users mysql
SQL
1 vote151 views2 answers
Replace text in sql
SQL
0 vote151 views1 answer
Psql list view rules
SQL
2 votes145 views1 answer
SQL IF ELSE
SQL
0 vote150 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
15 votes139 views2 answers
Install mysql 8 ubuntu 18.04
SQL