SQL ORDER BY Clause

Order by clause is used with SELECT statement for arranging retrieved data in sorted order. The Order by clause by default sorts the retrieved data in ascending order. To sort the data in descending order DESC keyword is used with Order by clause.

Syntax of Order By

SELECT column-list|* FROM table-name ORDER BY ASC | DESC;

Using default Order by

Consider the following Emp table,

SELECT * FROM Emp ORDER BY salary;

The above query will return the resultant data in ascending order of the salary.

Using Order by DESC

Consider the Emp table described above,

SELECT * FROM Emp ORDER BY salary DESC;

The above query will return the resultant data in descending order of the salary.

Check out other DCL commands and their usage:

• SELECT query
• WHERE clause
• LIKE clause
• Group BY clause
• Having clause