SQL Order By

SQL Order By

The SQL ORDER BY is used to sort the records of a select query.

Order By syntax

SELECT * FROM table_name ORDER BY column_name ASC | DESC;

Order By example

Coder books table

ID	Title	Price	Description
1	Learn SQL	20	Learn SQL language
2	Learn MySQL	22	Learn MySQL language
3	HTML book	17	Learn HTML
4	Learn PHP	20	Introduction to PHP
5	Learn PHP	20	PHP course

select * from coder_books order by price asc;

Result

ID	Title	Price	Description
3	HTML book	17	Learn HTML
4	Learn PHP	20	Introduction to PHP
5	Learn PHP	20	PHP course
1	Learn SQL	20	Learn SQL language
2	Learn MySQL	22	Learn MySQL language

select * from coder_books where price=20 order by id desc;

Result

ID	Title	Price	Description
5	Learn PHP	20	PHP course
4	Learn PHP	20	Introduction to PHP
1	Learn SQL	20	Learn SQL language