Learn how to use SQL ORDER BY clause to sort data in ascending and descending order. Find out how to order the filtered result using ORDER BY clause.
The WHERE clause also comes before the ORDER BY clause to apply the filter and sort the filtered result. However, if you forget to give attributes ASC|DSC after the ORDER BY clause, the SQL takes ASC as the default attribute.
The WHERE clause and the ORDER BY clause are optional to use in the SQL query. You can order one column or you can order more than one column using the syntax given below.
How to Use SQL ORDER BY Clause and Sort the Filtered Result
The syntax to use and order the result is given below. You have to use the ORDER BY clause after the WHERE clause. In addition to this, you have to use either ASC or DSC attribute to sort the data of the filtered result.
Here, one thing you should notice that all the data gets filtered first then after it will use the ORDER BY clause to sort the data at the end. That way, we have to use the ORDER BY clause at the end of the query statement.
Syntax1: ORDER BY Clause to Sort Single Column
|
1 2 3 4 |
SELECT column_name FROM tablename WHERE condition ORDER BY column_name ASC|DESC; |
The above syntax contains the SELECT statement with the name of the column and the table. You can use the WHERE clause to filter the result. In addition to this, you have to use the ORDER BY clause to sort the filtered result for one column using the above syntax.
You can order the result in ascending or descending using the attribute ASC|DESC.
Syntax2: ORDER BY Clause to Sort Multiple Column
|
1 2 3 4 |
SELECT column_name FROM tablename WHERE condition ORDER BY column_name1 ASC|DESC, column_name2 ASC|DESC; |
If you want to order multiple columns, you have to use the above syntax. The above syntax contains more than one column in ORDER BY clause with attribute option ASC or DESC for all the specified columns.
Parameter Descriptions
| Sr.No | Parameter Name | Description |
|---|---|---|
| 1 | column_name | Enter the column name you want to select for in the SELECT statement and another column in the ORDER BY clause to sort the data in order with this column. |
| 2 | tablename | Specify the table name from which you want to filter the result and sort order the data. |
| 3 | condition | Specify the condition in the WHERE clause with the operator, columns, and values to filter the result and order using the ORDER BY clause. |
|
1 2 3 4 |
SELECT Name FROM Employee WHERE Salary>25000 ORDER BY Category ASC; |
|
1 2 3 4 |
SELECT Name FROM Employee WHERE Salary>25000 ORDER BY Category ASC, Group DESC; |
You must also learn.
Reference