The social network for Oracle people
ORDER BY DESC
Now we want to select all the persons from the table above, however, we want to sort the persons descending by their last name.
We use the following SELECT statement:
SELECT * FROM Persons |
The result-set will look like this:
P_Id |
LastName |
FirstName |
Address |
City |
2 |
Svendson |
Tove |
Borgvn 23 |
Sandnes |
3 |
Pettersen |
Kari |
Storgt 20 |
Stavanger |
4 |
Nilsen |
Tom |
Vingvn 23 |
Stavanger |
1 |
Hansen |
Ola |
Timoteivn 10 |
Sandnes |
Views: 28
Comment
© 2013 Created by Eddie Awad.
You need to be a member of Oracle Community to add comments!
Join Oracle Community