Aggregate

LOGICAL_AND

BigQuery

Mengembalikan TRUE jika SEMUA nilai dalam group adalah TRUE. Seperti operator AND yang di-aggregate, berguna untuk mengecek apakah semua kondisi terpenuhi.

Tipe hasil: BOOLDiperbarui: 7 Jan 2026

Syntax

SQL

LOGICAL_AND(expression)

Parameter

expressionBOOLwajib

Ekspresi boolean yang akan di-AND kan

Contoh Penggunaan

Check All Items Approved

SQL

1 SELECT
2   order_id,
3   LOGICAL_AND(is_approved) as all_items_approved
4 FROM `project.dataset.order_items`
5 GROUP BY order_id;

Mengecek apakah semua item dalam order sudah di-approve.

Hasil

order_id	all_items_approved
O001	TRUE
O002	FALSE
O003	TRUE

Compliance Check per Department

SQL

1 SELECT
2   department,
3   LOGICAL_AND(training_completed) as all_trained,
4   LOGICAL_AND(certification_valid) as all_certified,
5   LOGICAL_AND(background_check_passed) as all_cleared
6 FROM `project.dataset.employees`
7 GROUP BY department;

Mengecek compliance status per departemen.

Hasil

department	all_trained	all_certified	all_cleared
Engineering	TRUE	TRUE	TRUE
Marketing	TRUE	FALSE	TRUE
Sales	FALSE	TRUE	TRUE

Data Quality Check

SQL

1 SELECT
2   table_name,
3   LOGICAL_AND(is_valid) as all_valid,
4   LOGICAL_AND(is_complete) as all_complete,
5   COUNT(*) as total_records
6 FROM `project.dataset.data_quality_log`
7 WHERE check_date = CURRENT_DATE()
8 GROUP BY table_name;

Monitoring data quality status per tabel.

Hasil

table_name	all_valid	all_complete	total_records
users	TRUE	TRUE	50000
orders	TRUE	FALSE	125000
products	FALSE	TRUE	8500

Fungsi Equivalen di Database Lain

BOOL_AND

PostgreSQL

BOOLAND_AGG

Snowflake

BOOL_AND

DuckDB

Fungsi Terkait

LOGICAL_OR

Kembali ke BigQuery Functions

1	SELECT
2	order_id,
3	LOGICAL_AND(is_approved) as all_items_approved
4	FROM `project.dataset.order_items`
5	GROUP BY order_id;

1	SELECT
2	department,
3	LOGICAL_AND(training_completed) as all_trained,
4	LOGICAL_AND(certification_valid) as all_certified,
5	LOGICAL_AND(background_check_passed) as all_cleared
6	FROM `project.dataset.employees`
7	GROUP BY department;

1	SELECT
2	table_name,
3	LOGICAL_AND(is_valid) as all_valid,
4	LOGICAL_AND(is_complete) as all_complete,
5	COUNT(*) as total_records
6	FROM `project.dataset.data_quality_log`
7	WHERE check_date = CURRENT_DATE()
8	GROUP BY table_name;