/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 vote326 views1 answer
Postgress append string in select
SQL
0 vote325 views1 answer
Search In the Data using ObjectName
SQL
0 vote348 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote355 views2 answers
Temp Space
SQL
24 votes342 views4 answers
Mysql datetime
SQL
0 vote341 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote372 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote319 views1 answer
Psql check if value in array
SQL
0 vote309 views1 answer
How to connect to mysql in ef 6
SQL
0 vote338 views1 answer
How to access to mysql without root
SQL