Math

GREATEST

BigQuery

Mengembalikan nilai terbesar dari daftar ekspresi.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

GREATEST(expression1, expression2, ...)

expression1, expression2, ...any comparablewajib

Dua atau lebih nilai yang bisa dibandingkan

SQL

1 SELECT
2   GREATEST(10, 5, 20, 15) as max_value,
3   GREATEST('apple', 'banana', 'cherry') as max_string;

Menemukan nilai terbesar dari list.

Hasil

max_value	max_string
20	cherry

SQL

1 SELECT
2   price,
3   GREATEST(price * 0.9, 10.0) as discounted_price
4 FROM `project.dataset.products`;

Diskon 10% tapi minimal harga 10.

1	SELECT
2	GREATEST(10, 5, 20, 15) as max_value,
3	GREATEST('apple', 'banana', 'cherry') as max_string;

1	SELECT
2	price,
3	GREATEST(price * 0.9, 10.0) as discounted_price
4	FROM `project.dataset.products`;