/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 vote132 views1 answer
Mssql last day of month
SQL
0 vote139 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote161 views1 answer
Jpa generationtype sequence mysql
SQL
2 votes86 views1 answer
Oracle current date without time
SQL
8 votes122 views4 answers
Mysql update one table from another table multiple columns
SQL
6 votes119 views4 answers
Sqlite drop table
SQL
3 votes125 views2 answers
Monthname sql
SQL
4 votes122 views2 answers
Sql vs mysql
SQL
0 vote122 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote90 views1 answer
Mysql timeout 30 seconds
SQL