Explain ORDER BY in Sql

In SQL, the ORDER BY clause is used to sort the result set of a query by one or more columns. You can specify whether to sort in ascending (ASC) or descending (DESC) order. By default, the ORDER BY clause sorts in ascending order.

Basic Syntax

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

Example

Assume we have a table named Employees with the following data:

Query to Sort by Age (Ascending)

SELECT * FROM Employees
ORDER BY Age;

Output:

Query to Sort by Age (Descending)

SELECT * FROM Employees
ORDER BY Age DESC;

Output:

Query to Sort by Multiple Columns

SELECT * FROM Employees
ORDER BY Age ASC, Salary DESC;

Output:

Here, the result set is first sorted by Age in ascending order. If there are ties in the Age, it further sorts by Salary in descending order.