How to use order by in SQL?

Question

Can anyone explain how to use order by in SQL?

Answer 1

Order by keyword is used to sort the query results in either ascending or descending order. By default, order by sorts the result-set in ascending order. Here is the syntax to use order by keyword in SQL:

SELECT column_list

FROM table_name

ORDER BY column(s) ASC|DESC;

Here is the statement to return the employee details in according to the descending order of their salaries:

SELECT E_ID, E_Name

FROM Employee

ORDER BY Salary DESC

You can go through this SQL Tutorial blog by Intellipaat for a detailed explanation of the order by clause.