Sorting Data Order By Clause in Oracle SQL

4 years ago

Written by shohal

ORDER BY keyword is used to sort the result-set in ascending or descending order.

ORDER BY Example


SELECT * FROM Customers
ORDER BY Department;

SELECT * FROM Customers

ORDER BY Department;

ORDER BY DESC Example


SELECT * FROM Customers
ORDER BY Department DESC;

SELECT * FROM Customers

ORDER BY Department DESC;