The ORDER BY Keyword

tags: #sql/basic_statements

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

The ORDER BY keyword sorts the records in ascending order by default.

To sort the records in descending order, use the DESC keyword:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;

To sort different columns in different orders:

SELECT tablename
FROM column1, column2,...
ORDER BY column1 ASC, column2 DESC;