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 vote152 views1 answer
How to add unique key constraint in mysql
SQL
0 vote164 views1 answer
Running percentage of total postgres
SQL
7 votes158 views6 answers
Mysql group concat
SQL
0 vote146 views1 answer
Incorrect string value: mysql
SQL
5 votes146 views1 answer
Oracle nls session
SQL
0 vote148 views1 answer
Drop CHECK constraint sql
SQL
0 vote171 views1 answer
How to check database engine in mysql
SQL
5 votes139 views2 answers
Mysqldump password
SQL
0 vote138 views1 answer
Mysql create table columns with spaces
SQL
0 vote137 views1 answer
Check index sql server
SQL