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

6 votes261 views4 answers
Delete table sqlite
SQL
0 vote252 views1 answer
Set mysql socket file docker windows
SQL
4 votes237 views2 answers
How to delete row in sql
SQL
1 vote268 views1 answer
Date_part mysql
SQL
0 vote266 views1 answer
Mysql last 6 months
SQL
0 vote272 views1 answer
Dockerfile example for Django
SQL
2 votes264 views3 answers
Sql function
SQL
0 vote251 views1 answer
Sql value exists in column
SQL
0 vote270 views1 answer
Closure in sql
SQL
16 votes246 views1 answer
CTE statement sql server
SQL