/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 vote306 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote292 views2 answers
How to find max and min salary in sql
SQL
0 vote304 views1 answer
Rename view mysql
SQL
0 vote280 views1 answer
Suse start MySQL
SQL
23 votes311 views1 answer
How remove column in mysql
SQL
0 vote286 views1 answer
Alter session set nls_language french
SQL
0 vote284 views1 answer
Drop check command
SQL
0 vote317 views1 answer
Sql server convert to guid
SQL
3 votes308 views1 answer
Stpop start psql server
SQL
2 votes322 views1 answer
Datetrunc
SQL