Math

LEAST

BigQuery

Mengembalikan nilai terkecil dari daftar ekspresi.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

LEAST(expression1, expression2, ...)

expression1, expression2, ...any comparablewajib

Dua atau lebih nilai yang bisa dibandingkan

SQL

1 SELECT
2   LEAST(10, 5, 20, 15) as min_value,
3   LEAST('apple', 'banana', 'cherry') as min_string;

Menemukan nilai terkecil dari list.

Hasil

min_value	min_string
5	apple

SQL

1 SELECT
2   quantity,
3   LEAST(quantity, 100) as capped_quantity
4 FROM `project.dataset.orders`;

Membatasi quantity maksimal 100.

1	SELECT
2	LEAST(10, 5, 20, 15) as min_value,
3	LEAST('apple', 'banana', 'cherry') as min_string;

1	SELECT
2	quantity,
3	LEAST(quantity, 100) as capped_quantity
4	FROM `project.dataset.orders`;