/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 vote300 views1 answer
Sql server query all database objects
SQL
3 votes202 views2 answers
Order by postgresql
SQL
0 vote185 views1 answer
Sql server whoami
SQL
0 vote158 views1 answer
Mysql select top 2
SQL
3 votes185 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
1 vote203 views1 answer
Age postgres
SQL
2 votes232 views1 answer
Create delete procedure mysql
SQL
5 votes213 views1 answer
Oracle list functions
SQL
1 vote178 views1 answer
Use of now() in mysql
SQL
1 vote221 views1 answer
Oracle list data files
SQL