87

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 –

ID	NAME	AGE	ADDRESS	SALARY
01	William	32	Karachi	72000
02	Avery	24	London	34000
03	Jackson	34	Paris	12000
04	Harper	20	United state	15000
05	Ella	22	Islamabad	33000
06	Monty	23	Turkey	42000
07	Mason	26	Saudi	50500

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.

ID	NAME	AGE	ADDRESS	SALARY
02	Avery	24	London	72000
05	Ella	22	Islamabad	34000
04	Harper	20	New York	12000
03	Jackson	34	Paris	15000
07	Mason	26	Saudi Arabia	33000
06	Monty	23	Turkey	42000
01	William	32	Karachi	50500

Example 2:

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

The above command will produce the following effect ?

ID	NAME	AGE	ADDRESS	SALARY
03	Jackson	34	Paris	50500
07	William	32	Karachi	42000
01	Mason	26	Saudi Arabia	33000
02	Avery	24	London	15000
06	Monty	23	Turkey	12000
05	Ella	22	Islamabad	34000
04	Harper	20	New York	72000

Example 3:

This command sorts the result in ascending order by ADDRESS.

The command gives the below output.

ID	NAME	AGE	ADDRESS	SALARY
05	Ella	22	Islamabad	33000
01	William	32	Karachi	72000
02	Avery	24	London	34000
03	Jackson	34	Paris	12000
07	Mason	26	Saudi	50500
06	Monty	23	Turkey	42000
04	Harper	20	United state	15000

---