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 vote300 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote228 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote223 views1 answer
Oracle procedure teamplate
SQL
1 vote230 views2 answers
Sql server concat string and int
SQL
0 vote213 views1 answer
Python mysql executemany
SQL
0 vote215 views1 answer
Sql column as header
SQL
0 vote225 views1 answer
Microsoft sql server python connection
SQL
0 vote202 views1 answer
How to install Firebird
SQL
0 vote209 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
14 votes234 views1 answer
Excel
SQL