/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 votes156 views3 answers
Sql server reseed identity column
SQL
0 vote144 views1 answer
Take sql dump in to file
SQL
2 votes141 views1 answer
Mysql clear screen
SQL
0 vote126 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote158 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote147 views1 answer
Sql delete dastabase
SQL
0 vote128 views1 answer
Mysql function variable
SQL
0 vote90 views1 answer
Mysql convert column to uppercase
SQL
0 vote155 views1 answer
Arithmetic expression in sql
SQL
0 vote126 views1 answer
Create new table pl sql
SQL