Conditional

GREATEST

DuckDB

Mengembalikan nilai terbesar dari daftar argumen. Skip NULL values kecuali semua NULL.

Tipe hasil: Tipe dari nilai terbesarDiperbarui: 6 Jan 2026

Syntax

SQL

GREATEST(value1, value2, ...)

value1, value2, ...ANY (comparable)wajib

Nilai-nilai yang akan dibandingkan

SQL

1 SELECT GREATEST(10, 20, 5, 15) AS max_value;

Mencari nilai terbesar.

Hasil

SQL

1 SELECT
2   product_name,
3   GREATEST(q1_sales, q2_sales, q3_sales, q4_sales) AS best_quarter
4 FROM sales_summary;

Mencari quarter dengan sales tertinggi.

SQL

1 SELECT
2   GREATEST(10, NULL, 5) AS with_null,
3   GREATEST(NULL, NULL) AS all_null;

NULL di-skip kecuali semua NULL.

Hasil

10 | NULL

SQL

1 SELECT
2   product_name,
3   GREATEST(price * 0.8, 10) AS sale_price
4 FROM products;

Diskon 20% tapi minimal price 10.

1	SELECT
2	product_name,
3	GREATEST(q1_sales, q2_sales, q3_sales, q4_sales) AS best_quarter
4	FROM sales_summary;

1	SELECT
2	GREATEST(10, NULL, 5) AS with_null,
3	GREATEST(NULL, NULL) AS all_null;