Clauses of Select Statment in SQL

ORDER BY Clause in SQL

IN SQL If you want to display the sorted list of the Table on the basis of specified column you can use the ORDER BY clause with SELECT statement. Order may be ascending order or descending order according to your requirement.

Syntax:

SELECT column_name FROM table_name WHERE condition ORDER BY column_name [ASC, DESC];

Where ASc,DESC means Ascending or Descending which is optional. If you Not specify the Order type then by default its sorted in Ascending order.

For example from table given below:

Actual Table

client_name city order_amount
Syed Tauqeer Karachi 50000
Muhammad Zia Ahmed Lahore 20000
Noman Bloch Karachi 30000
Imran Hadir Islamabad 10000
Muneer Bloch Karachi 15000
Muhammad Zia Khan Islamabad 30000

SELECT  *  FROM client_info ORDER BY  client_name ;

The above statement display the following record.

client_name

city

order_amount

Imran Hadir

Islamabad

10000

Muhammad Zia Ahmed

Lahore

20000

Muhammad Zia Khan

Islamabad

30000

Muneer Bloch

Karachi

15000

Noman Bloch

Karachi

30000

Syed Tauqeer

Karachi

50000