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 vote220 views1 answer
Sqlite update where exists
SQL
0 vote206 views1 answer
Sql query to select even numbers
SQL
0 vote180 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote164 views1 answer
Datetime postgres typeorm
SQL
-1 vote161 views2 answers
On update cascade
SQL
0 vote170 views1 answer
Alter table engine mysql
SQL
0 vote170 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
17 votes200 views1 answer
Selecting name that contain certain word in sql
SQL
3 votes172 views1 answer
Locate sql server
SQL
0 vote163 views1 answer
Drop constraint in ms sql
SQL