THE BEST WEB DEVELOPER SITE

SQL Operators


SQL Arithmetic Operators

Operator Description
+ Add
- Subtract
* Multiply
/ Divide
% Modulo

SQL Bitwise Operators

Operator Description
& Bitwise AND
| Bitwise OR
^ Bitwise exclusive OR

SQL Comparison Operators

Operator Description
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
<> Not equal to

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
ALL TRUE if all of a set of comparisons are TRUE
AND TRUE if both expressions are TRUE
ANY TRUE if any one of a set of comparisons are TRUE
BETWEEN TRUE if the operand is within the range of comparisons
EXISTS TRUE if a subquery contains any rows
IN TRUE if the operand is equal to one of a list of expressions
LIKE TRUE if the operand matches a pattern
NOT Reverses the value of any other operator
OR TRUE if either expression is TRUE
SOME TRUE if some of a set of comparisons are TRUE