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 vote180 views1 answer
View acl table oracle
SQL
0 vote288 views1 answer
Modificar tipo de dato sql server
SQL
0 vote210 views1 answer
Como hacer una consulta en sql
SQL
20 votes195 views5 answers
Mysql reset auto increment to 1
SQL
0 vote264 views1 answer
Soql last week
SQL
0 vote189 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
1 vote199 views1 answer
Oracle undo usage per session
SQL
1 vote199 views2 answers
Postgresql get difference in hours between two dates
SQL
21 votes161 views7 answers
Table drop if exist sql server
SQL
1 vote213 views1 answer
Where to locate set password for mysql
SQL