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 vote303 views1 answer
Mac mysql workbench console
SQL
0 vote321 views1 answer
SQL column name Oracle
SQL
8 votes327 views2 answers
How to fetch data from database without last column
SQL
0 vote334 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote298 views1 answer
How to change mysql port in xampp
SQL
0 vote308 views1 answer
Power bi find all ids not in other tables
SQL
1 vote293 views1 answer
Oracle list constraints
SQL
6 votes293 views1 answer
To count number of rows in SQL table
SQL
2 votes326 views1 answer
Ifnull postgres
SQL
1 vote311 views1 answer
Md5 encryption for existing records
SQL