SQL Logical Operators

SQL Logical Operators Following :

 Operators                         Description

ALL           -                         The ALL operator is used to compare a                                               value to all values in another value set. 

                                            

AND          -                         The AND operator allows the existence                                               of  multiple conditions in an SQL                                                           statement's WHERE clause.

ANY         -                          The ANY operator is used to compare a value to any applicable value in the                                                 list  according to the condition.

BETWEEN   -                       The BETWEEN operator is used to search for values that are within a set of                                                 values, given the minimum value and the maximum value.

EXISTS   -                            The EXISTS operator is used to search for the presence of a row in a                                                           specified table that meets certain criteria.

IN         -                               The IN operator is used to compare a value to a list of literal values that have                                                 been specified.

LIKE       -                            The LIKE operator is used to compare a value to similar values using wildcard                                              operators.

NOT       -                            The NOT operator reverses the meaning of the logical operator with which it is                                             used. Eg. NOT EXISTS, NOT BETWEEN, NOT IN etc. This is negate                                                     operator.

OR         -                             The OR operator is used to combine multiple conditions in an SQL statement's                                            WHERE clause.

IS NULL      -                      The NULL operator is used to compare a value with a NULL value.                      

UNIQUE       -                     The UNIQUE operator searches every row of a specified table for uniqueness                                              (no duplicates).