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

8 votes134 views1 answer
Oracle add auto_increment column to existing table
SQL
12 votes141 views1 answer
Env var for setting password for root user mysql docker hub
SQL
1 vote141 views2 answers
Begin transaction sql
SQL
0 vote129 views1 answer
Wordpress database query change url
SQL
1 vote117 views4 answers
Sql now
SQL
0 vote140 views1 answer
Oracle c# multiple update sql
SQL
0 vote159 views1 answer
Inner join distinct
SQL
0 vote132 views1 answer
Get week day name sql server
SQL
0 vote221 views1 answer
Oracle sql alter view add column
SQL
0 vote134 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