/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

2 votes138 views1 answer
How to check if a row is null in sql
SQL
0 vote128 views1 answer
Drop all tables in azure sql database
SQL
1 vote159 views1 answer
Mysql show database size in mb
SQL
0 vote139 views1 answer
Psql select * from table
SQL
1 vote148 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote141 views1 answer
My sql data file extention
SQL
0 vote155 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote134 views1 answer
Sauvegarde complète my sql
SQL
0 vote131 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote135 views1 answer
Sql datediff db2
SQL