SQL – Order By Clause
Table Of Contents:
- What Is SQL Order By Clause?
- Syntax Of Order By.
- Examples Of Order By.
(1) What Is SQL Order By Clause ?
- The
ORDER BY
the keyword is used to sort the result-set in ascending or descending order. - The
ORDER BY
keyword sorts the records in ascending order by default. To sort the records in descending order, use theDESC
keyword.
![](https://www.praudyog.com/wp-content/uploads/2023/04/39.jpg)
(2) Syntax Of SQL Order By Clause.
Syntax:
SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;
(3) Examples Of SQL Order By Clause.
Demo Data:
![](https://www.praudyog.com/wp-content/uploads/2023/04/11-1024x390.jpg)
Example-1: ORDER BY Country
SELECT * FROM Customers
ORDER BY Country;
![](https://www.praudyog.com/wp-content/uploads/2023/04/40-1024x310.jpg)
Example-2:ORDER BY DESC Example
SELECT * FROM Customers
ORDER BY Country DESC;
![](https://www.praudyog.com/wp-content/uploads/2023/04/41-1024x282.jpg)
Example-3:ORDER BY Several Columns
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;
![](https://www.praudyog.com/wp-content/uploads/2023/04/42-1024x275.jpg)