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

6 votes138 views1 answer
What is where clause in sql
SQL
0 vote177 views1 answer
Postgres foreign key multiple columns
SQL
4 votes143 views2 answers
Mysql delete user if exists
SQL
24 votes132 views6 answers
Rename a column in sql server
SQL
0 vote141 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote131 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote147 views1 answer
Postgresql check total storage
SQL
6 votes150 views4 answers
Mysql group by month
SQL
3 votes138 views2 answers
Oracle sql drop sequence
SQL
4 votes148 views1 answer
Group by mysql and concatenate string
SQL