What is the function of the ORDER BY clause?

Q: What is the function of the ORDER BY clause?

In MySQL, the **ORDER BY clause** is used to sort the rows returned by a query based on one or more columns. It controls the order in which the results appear, either in ascending or descending order. Sorts results in **ascending order** using `ASC` (default) or **descending order** using `DESC`. Can sort by one or multiple columns, e.g., `ORDER BY department_id, salary DESC`. Works with expressions or functions, e.g., `ORDER BY UPPER(name)`. Applied **after filtering** (`WHERE`) and **grouping** (`GROUP BY`) to organize the final result set. The ORDER BY clause is essential for presenting query results in a meaningful sequence, which is especially useful for reports and dashboards. SELECT name, salary, department_id FROM employees WHERE department_id = 3 ORDER BY salary DESC, name ASC;

Difficulty: 4/10

sorting, index usage, pagination

Understanding the ORDER BY Clause in MySQL

In MySQL, the ORDER BY clause is used to sort the rows returned by a query based on one or more columns. It controls the order in which the results appear, either in ascending or descending order.

Key Features of the ORDER BY Clause

1
Sorts results in ascending order using ASC (default) or descending order using DESC.
2
Can sort by one or multiple columns, e.g., ORDER BY department_id, salary DESC.
3
Works with expressions or functions, e.g., ORDER BY UPPER(name).

The ORDER BY clause is essential for presenting query results in a meaningful sequence, which is especially useful for reports and dashboards.

Example of ORDER BY Clause Usage

Scenario Questions

0-2 years experience

Follow-up Questions