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 vote245 views1 answer
Sql server locks
SQL
0 vote193 views1 answer
How to fetch unique records from two tables
SQL
1 vote280 views1 answer
How to select random rows from a table
SQL
5 votes197 views1 answer
Sort order on two columns sql
SQL
2 votes191 views2 answers
Get all tables using like
SQL
0 vote184 views1 answer
Sql composite key
SQL
1 vote212 views1 answer
Mysql order by desc null last
SQL
0 vote201 views1 answer
Sql output select
SQL
0 vote191 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote236 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL