Sorting Data

Sort by asc or desc:
SQL> select * from test order by salary desc;

TNO TNAME SALARY
---------- -------------------- ----------
3 kasarapu 5000
2 kumar 2000
1 vinay 1000

ASC --> Ascending order (default)

Sort by Alias Name:
SQL> select tname,salary*12 annsal from test order by annsal desc;

TNAME ANNSAL
-------------------- ----------
kasarapu 60000
kumar 24000
vinay 12000