/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

1 vote186 views1 answer
Sql week commencing date
SQL
0 vote186 views1 answer
Download mysql database to excel in android studio
SQL
25 votes192 views3 answers
Mysql command show tables
SQL
4 votes200 views1 answer
Oracle error line
SQL
0 vote147 views1 answer
Sql server is not
SQL
-1 vote206 views1 answer
Mysql order by on condition
SQL
0 vote223 views2 answers
Postgresql variable in query
SQL
0 vote212 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote188 views1 answer
Add plugins to mysql workbench
SQL
3 votes185 views1 answer
Get all elements sql
SQL