SQL Operators

Toggle navigation
TUTORIAL HOME
SQL Operators
❮ Previous Next ❯
SQL Arithmetic Operators
Operator Description Example
+ Add Try it
- Subtract Try it
* Multiply Try it
/ Divide Try it
% Modulo Try it
SQL Bitwise Operators
Operator Description
& Bitwise AND
| Bitwise OR
^ Bitwise exclusive OR
SQL Comparison Operators
Operator Description Example
= Equal to Try it
> Greater than Try it
< Less than Try it
>= Greater than or equal to Try it
<= Less than or equal to Try it
<> Not equal to Try it
SQL Compound Operators
Operator Description
+= Add equals
-= Subtract equals
*= Multiply equals
/= Divide equals
%= Modulo equals
&= Bitwise AND equals
^-= Bitwise exclusive equals
|*= Bitwise OR equals
SQL Logical Operators
Operator Description Example
ALL TRUE if all of a set of comparisons are TRUE Try it
AND TRUE if both expressions are TRUE Try it
ANY TRUE if any one of a set of comparisons are TRUE Try it
BETWEEN TRUE if the operand is within the range of comparisons Try it
EXISTS TRUE if a subquery contains any rows Try it
IN TRUE if the operand is equal to one of a list of expressions Try it
LIKE TRUE if the operand matches a pattern Try it
NOT Reverses the value of any other operator Try it
OR TRUE if either expression is TRUE Try it
SOME TRUE if some of a set of comparisons are TRUE Try it

❮ Previous Next ❯