SQL ORDER BY

In this tutorial, we will learn how to use ORDER BY Keyword to select records in ascending or descending order.

SQL ORDER BY Keyword

• ORDER BY keyword is used to sort the records in ascending or descending order.
• By Default, ORDER BY keyword sorts the records in ascending order.
• To sort the record in descending order, DESC keyword is used.

SELECT column1, column2,...columnN
FROM tableName
ORDER BY column1, column2,...ASC|DESC;

Example:

Let us consider this table "Employee" for records.

Table Name: Employee

ORDER BY Ascending

For selecting a salary by ascending, a query will be:

SELECT *
FROM Employee 
ORDER BY SALARY ASC

ORDER BY Descending

For selecting a salary by descending, a query will be:-

SELECT *
FROM Employee 
ORDER BY SALARY DESC

ORDER BY on multiple columns

For selecting multiple columns, one in ascending order and others in descending order, a query will be:

SELECT *
FROM Employee 
ORDER BY City ASC,EmpName DESC;