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 vote188 views1 answer
Sum values by month mariadb
SQL
0 vote189 views1 answer
Oracle calculate statistics on partition
SQL
1 vote194 views2 answers
Sql server concat string and int
SQL
0 vote191 views1 answer
Oracle simple quote
SQL
1 vote189 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote204 views1 answer
Neo4j command to run script file
SQL
1 vote189 views1 answer
Mysql how to reset primary key
SQL
4 votes179 views4 answers
What is primary key
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
0 vote180 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL