/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 vote330 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote327 views1 answer
Get the next column of a table in mysql
SQL
0 vote342 views1 answer
Neo4j command to run script file
SQL
0 vote338 views1 answer
How to get one year old query from plan cache
SQL
0 vote323 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
2 votes326 views4 answers
Sql query interview questions
SQL
0 vote307 views2 answers
Mysql add days to date
SQL
7 votes325 views4 answers
Mysql delete older duplicates
SQL
25 votes316 views4 answers
Metadata
SQL
0 vote346 views1 answer
Database schema for mcqs type exam in sql
SQL