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 vote405 views1 answer
What is common table expression in sql
SQL
1 vote351 views1 answer
Sql row having max
SQL
18 votes291 views4 answers
Foreign key mySql
SQL
0 vote323 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote319 views1 answer
Sql into vs insert into
SQL
8 votes322 views2 answers
Alert table name mysql
SQL
0 vote337 views1 answer
Postgresql port 5432 not open
SQL
0 vote313 views1 answer
Oracle c# multiple update sql
SQL
7 votes298 views1 answer
Oracle set sequence value to max(id)
SQL
8 votes310 views1 answer
Unique vs primary key
SQL