Aggregate

BOOLAND_AGG

Snowflake

Mengembalikan TRUE jika SEMUA nilai dalam grup adalah TRUE. Equivalent dengan logical AND agregat. Juga dikenal sebagai EVERY di SQL standard.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

BOOLAND_AGG(expression)

Parameter

expressionBOOLEANwajib

Kolom atau ekspresi boolean yang akan diagregasi

Contoh Penggunaan

Check All Tasks Completed

SQL

1 SELECT
2   project_id,
3   BOOLAND_AGG(is_completed) as all_tasks_done
4 FROM tasks
5 GROUP BY project_id;

Mengecek apakah semua task di setiap project sudah selesai.

Hasil

PROJECT_ID	ALL_TASKS_DONE
P001	TRUE
P002	FALSE
P003	TRUE

Validasi Data Quality

SQL

1 SELECT
2   batch_id,
3   BOOLAND_AGG(is_valid) as all_valid,
4   BOOLOR_AGG(is_valid) as any_valid,
5   COUNT(*) as total_records
6 FROM data_imports
7 GROUP BY batch_id;

Mengecek kualitas data: apakah semua valid atau ada yang valid.

Hasil

BATCH_ID	ALL_VALID	ANY_VALID	TOTAL_RECORDS
B001	TRUE	TRUE	1000
B002	FALSE	TRUE	950
B003	FALSE	FALSE	100

Fungsi Equivalen di Database Lain

BOOL_AND

PostgreSQL

LOGICAL_AND

BigQuery

BOOL_AND

DuckDB

Fungsi Terkait

BOOLOR_AGG

Kembali ke Snowflake Functions

1	SELECT
2	project_id,
3	BOOLAND_AGG(is_completed) as all_tasks_done
4	FROM tasks
5	GROUP BY project_id;

1	SELECT
2	batch_id,
3	BOOLAND_AGG(is_valid) as all_valid,
4	BOOLOR_AGG(is_valid) as any_valid,
5	COUNT(*) as total_records
6	FROM data_imports
7	GROUP BY batch_id;