/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

0 vote270 views1 answer
Acual month sql
SQL
1 vote334 views1 answer
Delete dublicate rows sql
SQL
1 vote274 views1 answer
Sql trigger before delete
SQL
38 votes364 views6 answers
Ubuntu install mysql client
SQL
3 votes281 views4 answers
Show databases in sql server
SQL
6 votes271 views2 answers
Drop foreign key
SQL
0 vote272 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote285 views2 answers
What is the default password for sql server sa
SQL
0 vote296 views1 answer
Connect by query in oracle
SQL
0 vote261 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL