/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 vote184 views1 answer
Influxdb export to csv
SQL
0 vote696 views1 answer
T sql less than date
SQL
0 vote196 views1 answer
ACCEPT nome PROMPT on oracle
SQL
2 votes208 views1 answer
Oracle trace file
SQL
3 votes209 views2 answers
Sql not contains
SQL
19 votes199 views6 answers
Sql server drop table if exists
SQL
32 votes194 views6 answers
Sql count where
SQL
3 votes194 views3 answers
Into in sql
SQL
0 vote177 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote170 views1 answer
Zerar auto increment mysql
SQL