USING OR

     This will gives the output when either of the conditions become true.

     Syntax:

         select * from <table_name> where <condition1> and <condition2> or ..

                                                                               <conditionn>;

     Ex:

         SQL> select * from student where no = 2 or marks >= 200;

         NO NAME            MARKS

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

         2   Saketh            200

         1   Jagan             300

         2   Naren             400