ORDER BY Clause

The output of SELECT queries does not have any specific order by default. The ORDER BY clause allows us to specify the order for the query output.

The ORDER BY clause is used with the SELECT statement to arrange retrieved data in a sorted order.

By default, the ORDER BY clause sorts the retrieved data in ascending order (ASC).

To sort the data in descending order, the DESC keyword is used with the ORDER BY clause.