/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

1 vote140 views1 answer
Order by oracle
SQL
5 votes238 views1 answer
Oracle asynchronous procedure
SQL
1 vote141 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote167 views1 answer
Sql track modification
SQL
10 votes153 views2 answers
Show tables in schema oracle
SQL
0 vote151 views1 answer
Excel export from sql using python
SQL
2 votes144 views2 answers
Sql first character
SQL
0 vote107 views1 answer
Alter session set nls_language french
SQL
2 votes131 views1 answer
Codeigniter print last sql query
SQL
4 votes147 views1 answer
Change nls_date_format
SQL