Order By

The ORDER BY statement sorts the retrieved rows in ascending (default) or descending order. In ascending order NULL values will come first and in descending order NULL values will come last.

Syntax

Default (Ascending)

SELECT <query-parameters> FROM <table-name> ORDER BY <column-name>;

Explicit Ascending

SELECT <query-parameters> FROM <table-name> ORDER BY <column-name> ASC;

Explicit Descending

SELECT <query-parameters> FROM <table-name> ORDER BY <column-name> DESC;

Example #1

SELECT * FROM Companies ORDER BY founded;

Example #2

SELECT * FROM Companies ORDER BY name DESC;