SQL ORDER BY
The keyword ORDER BY is used to sort the records of a sql query.
Syntax
SELECT * FROM name_of_table ORDER BY name_of_column ASC;
SELECT * FROM name_of_table ORDER BY name_of_column DESC;
Example
Table of books
| ID | NAME | PRICE |
|---|---|---|
| 1 | Learn Python | 45 |
| 2 | MySQL Tutorial | 32 |
| 3 | PHP examples | 24 |
| 4 | Learn SQL | 32 |
SELECT name, price FROM books ORDER BY price DESC;
Output
| NAME | PRICE |
|---|---|
| Learn Python | 45 |
| MySQL Tutorial | 32 |
| Learn SQL | 32 |
| PHP examples | 24 |