USING NOT IN

    This will gives the output  based on the column which values are not in the list of

      values  specified.

     Syntax:

         select * from <table_name> where <col> not in ( value1, value2, value3 … valuen);

     Ex:

         SQL> select * from student where no not in (1, 2, 3);

         NO NAME            MARKS

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

         4   Madhu

         5   Visu

         6   Rattu