|
Operator |
Description |
|
+ |
Add |
|
– |
Subtract |
|
* |
Multiply |
|
/ |
Divide |
|
% |
Modulo |
|
Operator |
Description |
|
& |
Bitwise AND |
|
| |
Bitwise OR |
|
^ |
Bitwise exclusive OR |
|
Operator |
Description |
|
= |
Equal to |
|
> |
Greater than |
|
< |
Less than |
|
>= |
Greater than or equal to |
|
<= |
Less than or equal to |
|
<> |
Not equal to |
|
Operator |
Description |
|
+= |
Add equals |
|
-= |
Subtract equals |
|
*= |
Multiply equals |
|
/= |
Divide equals |
|
%= |
Modulo equals |
|
&= |
Bitwise AND equals |
|
^-= |
Bitwise exclusive equals |
|
|*= |
Bitwise OR equals |
|
Operator |
Description |
|
ALL |
The condition returns TRUE only if all values from the subquery satisfy the requirement. |
|
AND |
The result is TRUE only when all conditions joined by AND are TRUE. |
|
ANY |
The condition returns TRUE if at least one value from the subquery satisfies the requirement. |
|
BETWEEN |
The condition returns TRUE if the operand falls within the range of comparisons. |
|
EXISTS |
The condition returns TRUE if the subquery yields one or more records. |
|
IN |
The condition returns TRUE if the operand matches any of the expressions in a provided list. |
|
LIKE |
The condition returns TRUE if the operand conforms to a specified pattern. |
|
NOT |
Display a record if the condition(s) is FALSE. |
|
OR |
The result is TRUE if any of the conditions joined by OR are TRUE. |
|
SOME |
The condition returns TRUE if any of the values from the subquery satisfy the requirement. |