PostgreSQL ORDER BY Clause

In PostgreSQL, 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.The ORDER BY clause helps to change this sequence



ORDER Syntax :

The syntax of the ORDER statement is −

SELECT column1,column2
FROM table_name
ORDER BY column1,column2 desc

ORDER Example :

Consider the STUDENT table is having the following records

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

SELECT * FROM STUDENT ORDER BY AGE ASC;

The result for the respective query is as follows −

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

SELECT * FROM STUDENT ORDER BY NAME DESC;

The result for the respective query is as follows −

---

Visit :

---

Discussion