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

1 vote193 views3 answers
How to pass password to mysql command line
SQL
0 vote166 views1 answer
Edit a field mysql terminal
SQL
3 votes162 views1 answer
System.debug apex
SQL
2 votes226 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
1 vote164 views2 answers
Setval max id postgresql sequence
SQL
3 votes166 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote169 views2 answers
Mysql create table if not exists
SQL
0 vote182 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote189 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote155 views1 answer
Mysql regex exact match
SQL