How to Use ORDER BY to Automatically Sort SQL Query Results

Query results are often returned in an arbitrary order, making the data look messy. The SQL ORDER BY clause is designed to organize the result set by specifying a sorting direction for one or more columns.

There are two sorting rules:

ASC : ascending order (smallest to largest). This is the default and can be omitted.

DESC : descending order (largest to smallest). This option is frequently used in production.

Typical scenarios for using ORDER BY include:

Displaying the most recent records first by sorting on a creation timestamp in descending order.

Sorting statistics by age, amount, or quantity.

Presenting list data in a tidy, ordered fashion.

Practical examples:

-- 1. Age ascending (smallest to largest)
SELECT * FROM UserInfo ORDER BY Age ASC;

-- 2. Creation time descending (newest users first, most common in work)
SELECT * FROM UserInfo ORDER BY CreateTime DESC;

-- 3. Multi‑field sorting: age descending, then user ID ascending
SELECT * FROM UserInfo ORDER BY Age DESC, UserID ASC;