USING IN

    This will gives the output based on the column and its list of values specified.

    Syntax:

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

     Ex:

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

         NO NAME            MARKS

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

         1   Sudha             100

         2   Saketh            200

         1   Jagan             300

         2   Naren             400

         3   Ramesh