SQL Operators
SQL Operators
An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s), such as comparisons and arithmetic operations. These Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.
SQL Arithmetic Operators
| Operators | Description |
| + | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Module |
SQL Comparison Operators
| Operators | Description |
| = | Equal to |
| > | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
SQL Compound Operators
| Operators | Description |
| += | Add equals |
| -= | Subtract equals |
*= | Multiply equals |
/= | Divide equals |
%= | Module equals |
&= | Bitwise AND equals |
| ^-= | Bitwise exclusive equals |
| |*= | Bitwise OR equals |
SQL Logical Operators
| Operators | Description |
| ALL | TRUE if all of the subquery values meet the condition |
| AND | TRUE if all the conditions separated by AND is TRUE |
ANY | TRUE if any of the subquery values meet the condition |
BETWEEN | TRUE if the operand is within the range of comparisons |
EXISTS | TRUE if the subquery returns one or more records |
IN | TRUE if the operand is equal to one of a list of expressions |
| LIKE | TRUE if the operand matches a pattern |
| NOT | Displays a record if the condition(s) is NOT TRUE |
| OR | TRUE if any of the conditions separated by OR is TRUE |
| SOME | TRUE if any of the subquery values meet the condition |
SQL Bitwise Operators
| Operators | Description |
| & | Bitwise AND |
| | Bitwise OR |
^ | Bitwise exclusive OR |