In and Not In

IN and NOT IN predicates:- The arithmetic operator = compares a single value . In case a value needs to be compared to a list of values the IN predicate is used. One can check a single value against multiple values by using IN predicate.
      The NOT IN predicate is opposite to the IN predicate. This will select all the rows where values do not match all of the values in the list.
Ex:-           1)  select * from vision where na in(‘prasad’,’rajesh’);
                  2)  select * from vision where na not in(‘prasad’,’rajesh’);

For
Online Classes

Contact Us: +919885348743