USING AND

    

     This will gives the output when all the conditions become true.

    

     Syntax:

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

                                                                                    <conditionn>;

     Ex:

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

                              NO NAME            MARKS

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

         2   Saketh            200

         2   Naren             400