Order by monthly in sql

SELECT     { fn MONTHNAME(OrderDate) } AS MonthName, YEAR(OrderDate) AS Year, SUM(TotalValue) AS Profits
FROM         [Order]
WHERE     (YEAR(OrderDate) = @year)
GROUP BY { fn MONTHNAME(OrderDate) }, MONTH(OrderDate), YEAR(OrderDate)
order by Year(orderDate),month(OrderDate)

Source: stackoverflow.com

Similar codes

0 vote307 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote293 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote267 views2 answers
Update information in a mysql column
SQL
0 vote251 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote268 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote280 views1 answer
Mysql uuid
SQL
0 vote264 views1 answer
How to open mysql in docker
SQL
9 votes254 views1 answer
Identity insert on sql server
SQL
0 vote273 views1 answer
Creating a simple notify in postgresql
SQL
0 vote275 views1 answer
Hoq to import database source
SQL