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

7 votes221 views1 answer
Sql disable safe mode
SQL
0 vote186 views1 answer
Restore backup mysql .gz
SQL
5 votes315 views2 answers
Mysql date greater than 30 days
SQL
0 vote187 views1 answer
How to run mysql in git bash
SQL
3 votes179 views1 answer
Only join in sql
SQL
1 vote205 views1 answer
T-sql disable system versioning
SQL
0 vote204 views2 answers
Plpgsql
SQL
0 vote196 views1 answer
Mysql root localhost run
SQL
0 vote219 views1 answer
Datagrip exec
SQL
0 vote183 views2 answers
Mysql dump database tables only
SQL