/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

2 votes199 views3 answers
How to replace null values in sql
SQL
1 vote143 views1 answer
Foreign key constraint in ms sql
SQL
0 vote143 views1 answer
Sql injection mitigation
SQL
20 votes157 views3 answers
Update values in select statement sql
SQL
0 vote155 views1 answer
Alter precision
SQL
7 votes153 views1 answer
Postgres base size
SQL
2 votes156 views1 answer
Mysql sysdate - 1 day
SQL
5 votes173 views6 answers
Sql foreign key
SQL
0 vote145 views1 answer
Stuff in sql server
SQL
0 vote155 views1 answer
Sql server update top n records
SQL