/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

3 votes212 views1 answer
If 0 return null else return query mysql
SQL
0 vote243 views1 answer
Renommer table sql
SQL
3 votes277 views1 answer
Mysql insert on dupèlicate
SQL
5 votes284 views2 answers
Postgresql add not null constraint
SQL
2 votes257 views2 answers
Mysql alter column default
SQL
2 votes252 views2 answers
Select list is not in group by clause
SQL
1 vote296 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes276 views1 answer
Revokeprivileges mysql
SQL
3 votes254 views2 answers
Enter mysql command line
SQL
0 vote244 views1 answer
Mysql trim characters
SQL