Terjemahan disediakan oleh mesin penerjemah. Jika konten terjemahan yang diberikan bertentangan dengan versi bahasa Inggris aslinya, utamakan versi bahasa Inggris. # Operator logis AWS IoT SiteWise mendukung operator logis berikut. | **Operator** | **Tanda tangan** | **Deskripsi** | | --- | --- | --- | | `AND` | a `AND` b | `TRUE`jika kedua nilai itu benar | | `OR` | a `OR` b | `TRUE`jika satu nilai benar | | `NOT` | `NOT`ekspresi | `TRUE`jika ekspresi salah, dan `FALSE` jika ekspresi benar | | `IN` | `IN`ekspresi x | `TRUE`jika nilai dalam ekspresi | | `BETWEEN` | `BETWEEN`a `AND` b | `TRUE`jika nilai antara batas atas dan bawah, dan mencakup kedua batas | | `LIKE` | `LIKE`pola | `TRUE`jika nilainya dalam pola
`LIKE`mendukung wildcard. Lihat di bawah untuk contoh:[See the AWS documentation website for more details](http://docs.aws.amazon.com/id_id/iot-sitewise/latest/userguide/sql-supported-logical.html) | Contoh dari semua operator logika: | **Fungsi** | **Contoh** | | --- | --- | | 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'
| | DI DALAM | 
SELECT a.asset_name 
   FROM asset AS a
   WHERE a.asset_name IN ('abc', 'pqr')
| | DI ANTARA | 
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'
| | SUKA | [See the AWS documentation website for more details](http://docs.aws.amazon.com/id_id/iot-sitewise/latest/userguide/sql-supported-logical.html) |