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

7 votes111 views1 answer
Xampp reset mysql
SQL
18 votes104 views6 answers
Drop table if exists
SQL
1 vote106 views1 answer
Sql string function update replace
SQL
14 votes104 views1 answer
Excel
SQL
27 votes120 views3 answers
Mysql show tables in database
SQL
0 vote135 views1 answer
Add new column in sql with foreign key
SQL
6 votes155 views2 answers
How to get last element sql
SQL
0 vote96 views1 answer
Sql random decimal
SQL
0 vote122 views1 answer
Sql last time database was accessed
SQL
0 vote105 views1 answer
Sql tabelle erstellen
SQL