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.
(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:
Example-1: ORDER BY Country
SELECT * FROM Customers
ORDER BY Country;
Example-2:ORDER BY DESC Example
SELECT * FROM Customers
ORDER BY Country DESC;
Example-3:ORDER BY Several Columns
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;