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 vote116 views2 answers
How to set global time_zone in mysql
SQL
1 vote115 views1 answer
Oracle sql create or replace view
SQL
28 votes112 views4 answers
Mysql delete database
SQL
3 votes119 views3 answers
Order by postgres
SQL
0 vote122 views1 answer
Sql get table last modified time
SQL
5 votes115 views2 answers
Sql conn
SQL
0 vote104 views1 answer
Change default schema sql server
SQL
0 vote116 views1 answer
Gcloud check sql
SQL
0 vote115 views1 answer
Sql developer connect to sql server
SQL
0 vote113 views1 answer
Authentication in sql server
SQL