/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 vote115 views1 answer
Sql delete dastabase
SQL
0 vote108 views1 answer
Mysql database is not starting in xampp
SQL
2 votes120 views1 answer
Sql find not in list
SQL
0 vote104 views1 answer
Sql replace id with name from another table
SQL
0 vote121 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote114 views1 answer
Sql change primary key to composite key
SQL
4 votes111 views1 answer
Restart for pg_hba.conf file
SQL
-1 vote115 views1 answer
How to check table exists or not in postgresql
SQL
0 vote124 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote111 views1 answer
Install ms sql server management studio
SQL