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 vote199 views1 answer
Add multiple row table pl sql
SQL
0 vote195 views1 answer
Mysql aspas simples
SQL
0 vote201 views1 answer
SQL joins in python
SQL
1 vote177 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote189 views1 answer
Change permission to database mysql
SQL
20 votes192 views6 answers
Mysql reset auto increment
SQL
1 vote183 views1 answer
Select if then postgresql
SQL
0 vote179 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote180 views1 answer
Fill up postgres db
SQL
0 vote182 views1 answer
How to select an index in oracle sql
SQL