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

3 votes283 views1 answer
Oracle revoke grant
SQL
2 votes297 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
2 votes353 views2 answers
MySql FULL OUTER JOIN
SQL
3 votes300 views1 answer
DB: in eloquent using sql
SQL
0 vote335 views1 answer
Mysql concatenate select results
SQL
6 votes281 views1 answer
What is where clause in sql
SQL
3 votes278 views1 answer
Postgres update column with value from another table
SQL
0 vote294 views1 answer
Sql developer connect to sql server
SQL
0 vote356 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote283 views1 answer
Oracle rolling back
SQL