USING ORDER BY

This will be used to ordering the columns data (ascending or descending).

Syntax:

        Select * from <table_name> order by <col> desc;

By default oracle will use ascending order.

If you want output in descending order you have to use desc keyword after the column.

Ex:

        SQL> select * from student order by no;

        NO NAME            MARKS

        ---  -------           ---------

         1   Sudha             100

         1   Jagan              300

         2   Saketh            200

         2   Naren             400

         3   Ramesh

         4   Madhu

         5   Visu

         6   Rattu

        SQL> select * from student order by no desc;

        NO NAME            MARKS

        ---  -------           ---------

         6 Rattu

         5 Visu

         4 Madhu

         3 Ramesh

         2 Saketh            200

         2 Naren             400

         1 Sudha             100

         1 Jagan             300