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 vote216 views1 answer
How to check rollback status in oracle
SQL
17 votes168 views6 answers
Mysql import sql file
SQL
-1 vote165 views2 answers
Postgres autoincrement primary key
SQL
0 vote177 views1 answer
Jdbc sql connection string
SQL
4 votes168 views1 answer
What are the data types in sql
SQL
0 vote166 views1 answer
Add timestamp column to existing table ms sql server
SQL
6 votes252 views1 answer
How to count number of rows in sql
SQL
31 votes182 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote183 views1 answer
Data directory postgresql
SQL
0 vote187 views1 answer
Query string starts with vowels
SQL