T-SQL ORDER BY

ORDER BY Clause sorts the database in increasing or decreasing order. To sort multiple columns at once, separate the column names by the operator (,) operator.

• ORDER BY sorts the data in ascending order by default.
• The DESC keyword is used to sort the data in descending order and ASC keyword is used to sort the database in ascending order.

Syntax of ORDER BY Clause:

Here: table_name: Name of the table.
column_name: Column of the database.
|: Use ASC or DESC to sort in ascending or descending order

Example:

Consider the CUSTOMERS table which has the below records -

Example 1:

Below command is the example, which sorts the result in ascending order by NAME and the SALARY.

The command gives the below output.

Example 2:

The command is the example, which sort the result in descending order by AGE.

The above command will produce the following effect ?

Example 3:

This command sorts the result in ascending order by ADDRESS.

The command gives the below output.