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 vote279 views1 answer
Mysql sql select one day before
SQL
0 vote282 views1 answer
Exclude last comma separated string mysql
SQL
0 vote284 views2 answers
Mysql unique two columns
SQL
3 votes282 views1 answer
Stpop start psql server
SQL
1 vote270 views1 answer
Oracle create program if no exists
SQL
9 votes267 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote285 views1 answer
Postgres statistics
SQL
0 vote295 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote276 views1 answer
Renombrar tabla mysql
SQL
2 votes289 views1 answer
How to get non distinct values in sql
SQL