本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。 # 邏輯運算子 AWS IoT SiteWise 支援下列邏輯運算子。 | **運算子** | **Signature** | **Description** | | --- | --- | --- | | `AND` | a `AND` b | `TRUE` 如果兩個值都是 true | | `OR` | a `OR` b | `TRUE` 如果一個值為 true | | `NOT` | `NOT` 表達式 | `TRUE` 如果表達式為 false，且`FALSE`如果表達式為 true | | `IN` | x `IN`表達式 | `TRUE` 如果表達式中的值 | | `BETWEEN` | `BETWEEN` a `AND` b | `TRUE` 如果值介於上限和下限之間，且包含兩個限制 | | `LIKE` | `LIKE` 模式 | `TRUE` 如果值處於模式
`LIKE` 支援萬用字元。如需範例，請參閱以下：[See the AWS documentation website for more details](http://docs.aws.amazon.com/zh_tw/iot-sitewise/latest/userguide/sql-supported-logical.html) | 所有邏輯運算子的範例： | **函數** | **範例** | | --- | --- | | 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'
| | 或 | 
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/zh_tw/iot-sitewise/latest/userguide/sql-supported-logical.html) |