|
Operator |
Description |
|
+ |
Add |
|
– |
Subtract |
|
* |
Multiply |
|
/ |
Divide |
|
% |
Modulo |
|
Operator |
Description |
|
& |
BitwiseAND |
|
| |
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 |
Returns true if all values from the subquery satisfy the condition. |
|
AND |
Returns true if all conditions connected by ‘AND’ are true. |
|
ANY |
Returns true if any of the values from the subquery satisfy the condition. |
|
BETWEEN |
Returns true if the operand falls within the range of comparisons. |
|
EXISTS |
Returns true if the subquery retrieves one or more records. |
|
IN |
Returns true if the operand matches any expression from a given list |
|
LIKE |
Returns true if the operand conforms to a specified pattern. |
|
NOT |
Displays a record if the condition(s) is false. |
|
OR |
Returns true if any of the conditions connected by ‘OR’ are true. |
|
SOME |
Returns true if any of the values from the subquery satisfy the condition.” |