Math

GREATEST

MySQL

Mengembalikan nilai terbesar dari daftar argumen. Minimal 2 argumen.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

GREATEST(value1, value2, ...)

value1, value2, ...any comparablewajib

Nilai-nilai yang akan dibandingkan

SQL

1 SELECT GREATEST(10, 25, 5, 30, 15) AS max_val;

Mencari nilai terbesar.

Hasil

max_val: 30

SQL

1 SELECT product, price,
2   GREATEST(price, 10.00) AS final_price
3 FROM products;

Harga minimal 10.00.

Hasil

(prices with minimum threshold)

SQL

1 SELECT order_id,
2   GREATEST(order_date, ship_date, deliver_date) AS latest
3 FROM orders;

Tanggal terbaru dari beberapa kolom.

Hasil

(latest date per order)

1	SELECT product, price,
2	GREATEST(price, 10.00) AS final_price
3	FROM products;

1	SELECT order_id,
2	GREATEST(order_date, ship_date, deliver_date) AS latest
3	FROM orders;