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 vote334 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote372 views1 answer
Insert set mysql
SQL
1 vote345 views1 answer
Media sql
SQL
0 vote367 views1 answer
Flexible search query delete table
SQL
0 vote408 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote353 views1 answer
Delete a record from a table sqlite3
SQL
1 vote383 views1 answer
Sql where max date
SQL
1 vote332 views1 answer
GROUP BY clause; this is incompati
SQL
-2 votes352 views1 answer
Group functions in sql
SQL
0 vote368 views3 answers
How to run sql query
SQL