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 vote246 views1 answer
Mysql tables max count
SQL
0 vote188 views4 answers
Sql year
SQL
0 vote262 views1 answer
Sql server is not
SQL
0 vote146 views1 answer
Check sql query executed wp
SQL
1 vote204 views1 answer
Mysql get max value and id
SQL
0 vote190 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote199 views1 answer
How to get one year old query from plan cache
SQL
12 votes185 views3 answers
Install sqlite driver ubuntu
SQL
0 vote280 views1 answer
How to login to mysql in homestead
SQL
0 vote245 views5 answers
Select concat alter table mysql
SQL