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

8 votes332 views2 answers
Python simple connect to mysql
SQL
3 votes309 views1 answer
Index using in query plsql
SQL
0 vote291 views1 answer
Print sum of values sql
SQL
3 votes353 views1 answer
Two select sql
SQL
0 vote327 views1 answer
Show table structure mysql console
SQL
0 vote344 views1 answer
Express api ith mysql data
SQL
1 vote362 views2 answers
Sql server backup table
SQL
19 votes344 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote347 views1 answer
Min mysql
SQL
0 vote313 views1 answer
Char varchar nvarchar sql
SQL