USING NOT BETWEEN

     This will gives the output based on the column which values are not in its lower bound,

     upperbound.

     Syntax:

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

                                                                         bound>;

     Ex:

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

         NO NAME            MARKS

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

         1   Sudha             100