What is the function of the ORDER BY clause?
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
Sorts results in ascending order using
ASC(default) or descending order usingDESC.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.
Example of ORDER BY Clause Usage