PartiQL in Amazon DynamoDB supports the following SQL standard
operators
Note
Any SQL operators that are not included in this list are not currently supported in DynamoDB.
Arithmetic operators
| Operator | Description |
|---|---|
+ |
Add |
- |
Subtract |
Comparison operators
| Operator | Description |
|---|---|
= |
Equal to |
<> |
Not Equal to |
!= |
Not Equal to |
> |
Greater than |
< |
Less than |
>= |
Greater than or equal to |
<= |
Less than or equal to |
Logical operators
| Operator | Description |
|---|---|
AND |
TRUE if all the conditions separated by AND
are TRUE |
BETWEEN |
This operator is inclusive of the lower and upper bound of the operands on which you apply it. |
IN |
TRUE if the operand is equal to one of a list of
expressions (at max 50 hash attribute values or at max 100 non-key attribute values) |
IS |
TRUE if the operand is a given, PartiQL data type, including
NULL or MISSING |
NOT |
Reverses the value of a given Boolean expression |
OR |
TRUE if any of the conditions separated by
OR are TRUE |
For more information about using logical operators, see Making comparisons and Logical evaluations.
