/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 vote102 views1 answer
Install mysql 8 linux
SQL
3 votes108 views4 answers
Ubuntu stop mysql
SQL
0 vote116 views1 answer
Alter table engine mysql
SQL
1 vote103 views1 answer
Mysql select row with max value group by
SQL
1 vote108 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote135 views1 answer
Oracle create package specification
SQL
0 vote118 views2 answers
How to count codition
SQL
0 vote118 views1 answer
Oracle search in date columns
SQL
2 votes113 views1 answer
Find all triggers in database
SQL
4 votes113 views1 answer
Mysql biginteger size
SQL