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 vote278 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote269 views1 answer
Restore backupfile discourse
SQL
3 votes279 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote263 views1 answer
Flask sqlalchemy update row
SQL
0 vote285 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote263 views1 answer
Select only one row sql
SQL
11 votes299 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote291 views1 answer
Wordpress database query change url
SQL
0 vote287 views1 answer
Postgresql auto increment not working
SQL
0 vote301 views1 answer
Mysql error 1114 (hy000) the table is full
SQL