1.  Arithmetic Operators
  2. Comparison Operators
  3. Logical Operators

SQL Arithmetic Operators

Addition +, add two value
Subtraction -, Subtracts right hand operand from left hand operand.
Multiplication *, Multiply two value
Division /, Divides left hand operand by right hand operand
Modulus % , Divides left hand operand by right hand operand and returns the remainder

SQL Comparison Operators

 

 

< Less than
> Greater than
<= Less than or equal
>= Greater than or equal
= Equal
!= Not equal
<> Not equal
!< Not less than
>! Not greater than

SQL Logical Operators

 

ALL
ANY
AND
OR
IN
BETWEEN
EXISTS
LIKE
NOT
UNIQUE
IS NULL
Sharing is Caring
Scroll to Top