Aggregate

BOOLOR_AGG

Snowflake

Mengembalikan TRUE jika MINIMAL SATU nilai dalam grup adalah TRUE. Equivalent dengan logical OR agregat.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

BOOLOR_AGG(expression)

Parameter

expressionBOOLEANwajib

Kolom atau ekspresi boolean yang akan diagregasi

Contoh Penggunaan

Check Any Error Exists

SQL

1 SELECT
2   job_id,
3   BOOLOR_AGG(has_error) as any_errors
4 FROM job_executions
5 GROUP BY job_id;

Mengecek apakah ada error di salah satu execution dari setiap job.

Hasil

JOB_ID	ANY_ERRORS
J001	FALSE
J002	TRUE
J003	FALSE

Customer Has Premium Product

SQL

1 SELECT
2   customer_id,
3   BOOLOR_AGG(is_premium) as has_premium_product
4 FROM orders o
5 JOIN products p ON o.product_id = p.id
6 GROUP BY customer_id;

Mengecek apakah customer pernah membeli produk premium.

Hasil

CUSTOMER_ID	HAS_PREMIUM_PRODUCT
CUST-001	TRUE
CUST-002	FALSE
CUST-003	TRUE

Fungsi Equivalen di Database Lain

BOOL_OR

PostgreSQL

LOGICAL_OR

BigQuery

BOOL_OR

DuckDB

Fungsi Terkait

BOOLAND_AGG

Kembali ke Snowflake Functions

1	SELECT
2	job_id,
3	BOOLOR_AGG(has_error) as any_errors
4	FROM job_executions
5	GROUP BY job_id;

1	SELECT
2	customer_id,
3	BOOLOR_AGG(is_premium) as has_premium_product
4	FROM orders o
5	JOIN products p ON o.product_id = p.id
6	GROUP BY customer_id;