SQL ORDER BY Clause

The ORDER BY Clause is used to sort the results either in ascending or descending order based on one or more columns.
Oracle and some other database sorts query results in ascending order by default.

Syntax:

SELECT * FROM tableName [WHERE condition] [ORDER BY column1, column2,…,columnN] [ASC | DESC];
Where ASC keyword is used for ascending order and DESC keyword is used for descending order.

 Example:

SELECT * FROM EMPLOYEE ORDER BY EMP_NAME;

Output:

EMP_ID EMP_NAME AGE SALARY
3 Nidhi 28 48000
4 Parbhjot 29 46000
1 Parbhjot 28 35000
5 Parmender 28 45000
2 Parmender 28 45000

No comments: