Aggregate

BOOL_AND

DuckDB

Mengembalikan TRUE jika SEMUA nilai dalam grup adalah TRUE. Jika ada satu saja FALSE, hasilnya FALSE. Equivalent dengan logical AND pada semua nilai.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

BOOL_AND(expression)

Parameter

expressionBOOLEANwajib

Kolom atau ekspresi boolean yang akan di-AND-kan

Contoh Penggunaan

Cek Apakah Semua Item Approved

SQL

1 SELECT
2   order_id,
3   BOOL_AND(is_approved) as all_approved
4 FROM order_items
5 GROUP BY order_id;

Mengecek apakah SEMUA item dalam order sudah di-approve.

Hasil

order_id	all_approved
1001	true
1002	false
1003	true

Validasi Completeness per Batch

SQL

1 SELECT
2   batch_id,
3   BOOL_AND(is_validated) as fully_validated,
4   BOOL_AND(is_processed) as fully_processed,
5   COUNT(*) as record_count
6 FROM batch_records
7 GROUP BY batch_id;

Mengecek apakah SEMUA record dalam batch sudah divalidasi dan diproses.

Hasil

batch_id	fully_validated	fully_processed	record_count
B001	true	true	500
B002	true	false	320
B003	false	false	180

Compliance Check

SQL

1 SELECT
2   department,
3   BOOL_AND(completed_training) as all_trained,
4   BOOL_AND(signed_policy) as all_signed,
5   CASE
6     WHEN BOOL_AND(completed_training AND signed_policy)
7     THEN 'Compliant'
8     ELSE 'Non-Compliant'
9   END as compliance_status
10 FROM employees
11 GROUP BY department;

Mengecek apakah semua karyawan di departemen memenuhi requirement compliance.

Hasil

department	all_trained	all_signed	compliance_status
IT	true	true	Compliant
Sales	true	false	Non-Compliant

Fungsi Terkait

BOOL_OR

Kembali ke DuckDB Functions

1	SELECT
2	order_id,
3	BOOL_AND(is_approved) as all_approved
4	FROM order_items
5	GROUP BY order_id;

1	SELECT
2	batch_id,
3	BOOL_AND(is_validated) as fully_validated,
4	BOOL_AND(is_processed) as fully_processed,
5	COUNT(*) as record_count
6	FROM batch_records
7	GROUP BY batch_id;

1	SELECT
2	department,
3	BOOL_AND(completed_training) as all_trained,
4	BOOL_AND(signed_policy) as all_signed,
5	CASE
6	WHEN BOOL_AND(completed_training AND signed_policy)
7	THEN 'Compliant'
8	ELSE 'Non-Compliant'
9	END as compliance_status
10	FROM employees
11	GROUP BY department;