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 vote209 views1 answer
Sql server on mac m1
SQL
0 vote200 views1 answer
How get data from database if id not found then search another column
SQL
0 vote202 views1 answer
What is SQL data store?
SQL
2 votes201 views1 answer
How to make insert script from table in SQL server
SQL
1 vote217 views1 answer
Top 10 rows in mysql
SQL
0 vote348 views1 answer
Get first match in each group mysql query
SQL
0 vote223 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes222 views1 answer
Postgresql create schema in specific database
SQL
0 vote220 views1 answer
Object of class mysqli_result could not be converted to string
SQL
17 votes228 views4 answers
Show tables sql server
SQL