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

11 votes112 views5 answers
How to install sqlite3 python
SQL
0 vote117 views1 answer
Sqlcmd no headers
SQL
2 votes128 views2 answers
How to run postgresql in linux
SQL
0 vote185 views1 answer
Mysql delete entire row on condition
SQL
0 vote80 views1 answer
Como leer datos de mysql esp32
SQL
0 vote168 views1 answer
Selecting from a view SQL
SQL
1 vote132 views1 answer
Postgres cast as currency format
SQL
24 votes134 views4 answers
Delete db postgres
SQL
4 votes118 views1 answer
Change nls_date_format
SQL
0 vote121 views1 answer
Sql column contains special character
SQL