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 vote109 views1 answer
MySQL import data from large CSV file
SQL
0 vote60 views1 answer
Update set with join pl sql
SQL
0 vote107 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote96 views1 answer
Postrgres trunc
SQL
0 vote111 views1 answer
Sql check if column exists
SQL
0 vote101 views1 answer
Show function mysql
SQL
5 votes103 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote96 views1 answer
Mysql update privileges
SQL
0 vote107 views1 answer
Creation d'un trigger sql
SQL
0 vote122 views1 answer
Ubuntu connect to mssql database
SQL