/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 vote143 views1 answer
Postgresql delete limit
SQL
3 votes176 views2 answers
Brew restart mysql
SQL
3 votes132 views1 answer
Oracle wait
SQL
1 vote148 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
1 vote146 views1 answer
Oracle index partition
SQL
0 vote145 views2 answers
How to drop mili second in sql
SQL
-1 vote197 views5 answers
Left join sql
SQL
0 vote202 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote132 views1 answer
Mysql add to value
SQL
0 vote144 views1 answer
Join in update query in mysql
SQL