Text copied!
ORDER BY clause
SQL clause is the specific part of a SQL statement which is used to perform various operations. It can be combined to create more complex queries to retrieve and manipulate data.
ORDER BY clause :
ORDER BY clause is used to sort the data in ascending or descending order based on column(s). It is often used with other clauses such as 'SELECT', 'FROM', 'HAVING' and 'ORDER BY' etc. to retrieve, specify table, filter, sort and manipulate data.
The syntax of the ORDER BY clause generally looks like this :
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC;
• Specify the column(s) name after the 'SELECT' keyword.
• Specify Asterisk (*) symbol to selects all columns from the table after the 'SELECT' keyword.
• Specify the table name after the 'FROM' keyword.
• Specify the column(s) name and sorting order after the 'ORDER BY' keyword. 'ASC' stands for ascending order and 'DESC' stands for descending order. if you don't mention the sorting order, 'ASC' is default.
Here's an example of how you might use the ORDER BY clause :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to retrieve the employees salary from highest to lowest in the [Employees] table.
3. Run below SQL statement :
SELECT *
FROM [Employees]
ORDER BY Salary DESC;
4. Above statement will sort each rows in descending order based on the salary column from the [Employees] table.
That's it! You have successfully sorted the data in descending order from [Employees] table.