/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 vote241 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote228 views1 answer
Sqlite referential integrity
SQL
1 vote240 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
20 votes221 views2 answers
Mysql bigint max value
SQL
0 vote239 views1 answer
Synapse sql table set pk
SQL
1 vote253 views1 answer
Oracle check table lock
SQL
5 votes220 views1 answer
Oracle list packages
SQL
5 votes236 views3 answers
Oracle list columns in schema
SQL
0 vote217 views1 answer
Check index sql server
SQL
1 vote228 views1 answer
Truncate left characters mysql
SQL