An operator is a word or character reserved primarily for operations like comparisons and arithmetic operations, used in the WHERE clause of a SQL query. These operators are used in a SQL statement to declare conditions and provide numerous situations in a query.
Suppose that variable an is 10 and that variable b is 20 then –
Operator  Description  Example 

+ (Addition)  Adds values on either side of the operator.  a + b will give 30 
 (Subtraction)  Right hand operand of the left hand operand is subtracted.  a  b will give 10 
* (Multiplication)  Multiplies the operator's values on either side.  a * b will give 200 
/ (Division)  The left hand is divided by the right hand hand operand.  b / a will give 2 
% (Modulus)  Divide the left hand operand and return the rest.  b % a will give 0 
Suppose that variable an is 10 and that variable b is 20 then –
Operator  Description  Example 

=  Checks whether the values of two transactions are equivalent or not.  (a = b) is not true. 
!=  Checks whether the values of both operands are the same or not, and whether the values are not the same, the condition becomes true.  (a != b) is true. 
<>  Checks whether the values of both operands are the same or not, and whether the values are not the same, the condition becomes true.  (a <> b) is true. 
>  If yes then the condition is true, verify if the value of the left operand is greater than the value of the right operand.  (a > b) is not true. 
<  If yes, then it is true if the value of the left operand is lower than that of the right operand.  (a < b) is true. 
>=  Checks if the leftoperand value is greater or equal to the rightoperand value, if the condition is true.  (a >= b) is not true. 
<=  Checks if the left operand value is smaller or equal to the right operand value, if yes then the condition is true.  (a <= b) is true. 
!<  Checks if the left operand value is no smaller than the right operand value, if yes, then the condition is true.  (a !< b) is false. 
!>  Checks if the left operand value does not exceed the right operand value, if yes the condition then becomes true.  (a !> b) is true. 
This is a list of all SQL logical operators.
Sr.No  Operator & Description 

1  ALL The ALL operator compares a value to all values in a different set of values. 
2  AND The AND operator permits multiple conditions to exist in the WHERE clause of a SQL query. 
3  ANY The ANY operator is used to compare a value with any value in the list, depending on the criterion. 
4  BETWEEN In the case of a minimum value and the maximum value, the BETWEEN operator can search for values inside a set of values. 
5  EXISTS EXISTS A ROWER in a given table that meets a certain requirement is used to search for the existence of a row. 
6  IN The IN operator compares a value with a list of the provided literal values. 
7  LIKE The LIKE operator uses wildcard operators to compare the same value with comparable values. 
8  NOT The NOT operator reverses the significance of the logical user it is used with. For example: NOT ARE, NOT ARE, etc. This is an operator that is negative. 
9  OR The OR operator can be used in a WHERE SQL statement to combine multiple conditions. 
10  IS NULL Using NULL, a value is compared with a value of NULL. 
11  UNIQUE Each row of the table supplied is searched by the UNIQUE operator (no duplicates). 
