|
The Order By keyword is used to sort the result-set of select statement by a specified column name. It will sort the records in ascending or descending order. By default it sorts in ascending order.
Table Name ‘Users’
|
U_Id
|
FirstName
|
LastName
|
City
|
|
1
|
Ajay
|
senha
|
New York
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
3
|
Qasim
|
bilal
|
New York
|
SELECT * FROM Users
ORDER BY FirstName Asc
Result:
|
U_Id
|
FirstName
|
LastName
|
City
|
|
1
|
Ajay
|
senha
|
New York
|
|
3
|
Qasim
|
bilal
|
New York
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
SELECT * FROM Users
ORDER BY FirstName Desc
Result:
|
U_Id
|
FirstName
|
LastName
|
City
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
3
|
Qasim
|
bilal
|
New York
|
|
1
|
Ajay
|
senha
|
New York
|
|