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 vote136 views1 answer
Drop unique
SQL
0 vote140 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote119 views1 answer
Mysql date minus 1 day
SQL
29 votes117 views6 answers
Delete all rows from table mysql
SQL
0 vote128 views1 answer
Incorrect string value: mysql
SQL
2 votes124 views2 answers
Sql query to list all tables in a database sql server
SQL
2 votes154 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote136 views1 answer
Mysql pv progres
SQL
4 votes143 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote125 views1 answer
Psql human readable
SQL