/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

244 votes207 views14 answers
Sql n insert
SQL
0 vote125 views1 answer
Create table split string function in sql server
SQL
2 votes135 views3 answers
Sql interview query questions
SQL
14 votes134 views4 answers
Online sql compiler
SQL
0 vote121 views1 answer
Postgres - Login and connect as default user
SQL
1 vote113 views1 answer
Oracle convert run duration to number
SQL
0 vote110 views1 answer
SQL loop with cursor
SQL
3 votes197 views2 answers
Savepoint in sql
SQL
0 vote119 views1 answer
Sql drop default
SQL
0 vote126 views1 answer
Mysql terminal run sql file
SQL