MySQL Order By

MySQL Order By

MySQL Order By syntax and examples.

MySQL Order By syntax

SELECT * FROM table_name
ORDER BY column;

SELECT * FROM table_name
WHERE condition ORDER BY column;

Table books

ID NAME PRICE
1 book1 20.0
2 book2 25.0
3 book3 15.0
4 book4 12.0
5 book5 18.0

Order By example

SELECT * FROM books 
WHERE id > 2
ORDER BY price;

Query Result

ID NAME PRICE
4 book4 12.0
3 book3 15.0
5 book5 18.0