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 vote352 views1 answer
Postgresql define pk sequence next number
SQL
1 vote291 views2 answers
Show sql logs in spring boot
SQL
0 vote322 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote329 views1 answer
Mysqldump don't drop table
SQL
0 vote344 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote383 views1 answer
Sql int vs integer
SQL
0 vote321 views1 answer
Backup a table in sql
SQL
0 vote325 views2 answers
Install phoenix
SQL
1 vote386 views1 answer
Sql count value greater than
SQL
0 vote359 views1 answer
Sqlalchemy empty table
SQL