Order By

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

SELECT name, price FROM books ORDER BY price DESC;

Output