USING BETWEEN

     This will gives the output based on the column and its lower bound, upperbound.

     Syntax:

         select * from <table_name> where <col> between <lower bound> and <upper

                                                                                        bound>;

     Ex:

         SQL> select * from student where marks between 200 and 400;

         NO NAME            MARKS

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

         2   Saketh            200

         1   Jagan              300

         2   Naren              400