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 |
Select Command
Distinct clause with Select Command
Where clause In SQL
Logical Operator in SQL SELECT Statement
IN Operator in SQL
BETWEEN Operator in SQL
Use of Wildcards in SQL
LIKE Operator in SQL
ORDER BY Clause in SQL
GROUP BY Clause in SQL
HAVING Clause in SQL
ALIAS In SQL
AS Keyword In SQL
INSERT INTO Command In SQL
Inserting Record In to a Table Form an other Table In SQL
UPDATE Command in SQL
DELETE Command in SQL
AVG Function in SQL