/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 vote344 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote383 views1 answer
Mysql create index lost connection
SQL
0 vote328 views1 answer
Components/Fields of Internal Table
SQL
18 votes348 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote345 views1 answer
Sql convert float to string
SQL
2 votes345 views1 answer
How to delete view in sql
SQL
7 votes331 views3 answers
How to check table name in current database sql
SQL
0 vote334 views1 answer
Python mysql executemany
SQL
0 vote348 views2 answers
How to install mssql on mac
SQL
4 votes355 views2 answers
REST API
SQL