SQL ORDER BY Keyword

In SQL, the ORDER BY keyword is used to sort the resultant records in ascending or descending order.We use the ASC keyword to sort records in ascending order and we use DESC to sort records in descending order. By default the keyword sort the records in ascending order.

ORDER BY Syntax :

The syntax of the ORDER BY Keyword is −

SELECT column1, column2, ... columnN
FROM table-name
ORDER BY column1, column2, ... columnN ASC|DESC;

ORDER BY Keyword Example :

Consider the Customer table with the following records -

TEST CASE 1 :- The following code is an example, which would fetch the all record from Customer table and sorted by the "Address" column.

SELECT * FROM Customer
ORDER BY Address;

The result for the respective sql query is as follows −

TEST CASE 2:- The following code is an example, which would fetch the all record from Customer table and sorted by the "Address" column in descending order.

SELECT * FROM Customer
ORDER BY Address DESC;

The result for the respective sql query is as follows −

---

Visit :

---

Discussion