Logical Operators in SQL

The Logical Operators in SQL perform the Boolean operations, which give two results True and False.

Operator                      Description                  
 ALL                             The All operator in SQL TRUE when compare a value to all values of subquery result.                       
 AND                            The AND operator in SQL TRUE when all condition is TRUE.                  
 OR                              The OR operator in SQL TRUE when any one condition is TRUE.                              
 BETWEEN                  The BETWEEN operator in SQL TRUE when range of comparisions is TRUE.            
 IN                                The IN operator in SQL TRUE when at list one or more match.  
 NOT                            The NOT operator in SQL TRUE when record not match.(NOT IN, NOT EXITS,NOT BETWEEN)               
 ANY                            The ANY operator in SQL TRUE when equal to any value in the list.  
 LIKE                            The LIKE operator in SQL TRUE when compare a value to similar values using wildcard operators.
 EXITS                         The EXITS operator in SQL TRUE when at least one tuple is the result of nested query.