# Logical operators
AWS IoT SiteWise supports the following logical operators.
| **Operator** | **Signature** | **Description** |
| --- | --- | --- |
| `AND` | a `AND` b | `TRUE` if both values are true |
| `OR` | a `OR` b | `TRUE` if one value is true |
| `NOT` | `NOT` expression | `TRUE` if an expression is false, and `FALSE` if an expression is true |
| `IN` | x `IN` expression | `TRUE` if value in expression |
| `BETWEEN` | `BETWEEN` a `AND` b | `TRUE` if value between upper and lower limit, and includes both limits |
| `LIKE` | `LIKE` pattern | `TRUE` if value is in pattern `LIKE` supports wildcards. See below for examples: [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/iot-sitewise/latest/userguide/sql-supported-logical.html) |
Examples of all logical operators:
| **Function** | **Example** |
| --- | --- |
| AND | SELECT a.asset_name
FROM asset AS a, latest_value_time_series AS t
WHERE t.int_value > 30 AND t.event_timestamp > TIMESTAMP '2025-05-15 00:00:01'
|
| OR | SELECT a.asset_name
FROM asset AS a
WHERE a.asset_name like 'abc' OR a.asset_name like 'pqr'
|
| NOT | SELECT ma.asset_id AS a_id
FROM asset AS ma
WHERE (ma.asset_id NOT LIKE 'some%patterna%' escape 'a') AND ma.asset_id='abc'
|
| IN | SELECT a.asset_name
FROM asset AS a
WHERE a.asset_name IN ('abc', 'pqr')
|
| BETWEEN | SELECT asset_id, int_value, event_timestamp AS i_v
FROM raw_time_series
WHERE event_timestamp BETWEEN TIMESTAMP '2025-04-15 00:00:01' and TIMESTAMP '2025-05-15 00:00:01'
|
| LIKE | [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/iot-sitewise/latest/userguide/sql-supported-logical.html) |