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

1 vote325 views1 answer
Mysql view command
SQL
0 vote327 views1 answer
Search column name sql
SQL
11 votes303 views2 answers
Having keyword sql
SQL
0 vote324 views1 answer
Mysql select where field like in list
SQL
1 vote354 views2 answers
Sql insert timestamp
SQL
0 vote350 views1 answer
Mysql user set plugin
SQL
0 vote311 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
4 votes307 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote312 views1 answer
Turn on foreign keys check mysql
SQL
0 vote368 views1 answer
Stored procedure function relation
SQL