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 vote281 views1 answer
C# select Mysql
SQL
0 vote305 views1 answer
Mysql query to select the highest value
SQL
1 vote319 views2 answers
Extract weekday from date in sql
SQL
0 vote306 views1 answer
On delete set default
SQL
3 votes295 views3 answers
C# sql select
SQL
0 vote310 views1 answer
Insert set mysql
SQL
1 vote297 views2 answers
Postgres copy table from one schema to another
SQL
4 votes294 views1 answer
Oracle session date format
SQL
0 vote295 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote294 views1 answer
Sql delete row with auto increment
SQL