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 vote189 views2 answers
Mysql create table if not exists
SQL
3 votes190 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote190 views1 answer
Oracle apex prevent initial load
SQL
1 vote190 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote187 views1 answer
Update one column from another column in same table
SQL
6 votes176 views1 answer
Oracle rank() over (partition)
SQL
1 vote170 views1 answer
Can we drop a primary key
SQL
2 votes150 views1 answer
Sql float to int
SQL
1 vote201 views1 answer
Oracle difference between two dates in years
SQL
0 vote198 views1 answer
Create table database in psql
SQL