Math

LEAST

MySQL

Mengembalikan nilai terkecil dari daftar argumen. Kebalikan dari GREATEST.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

LEAST(value1, value2, ...)

value1, value2, ...any comparablewajib

Nilai-nilai yang akan dibandingkan

SQL

1 SELECT LEAST(10, 25, 5, 30, 15) AS min_val;

Mencari nilai terkecil.

Hasil

min_val: 5

SQL

1 SELECT product, price,
2   LEAST(price, 100.00) AS capped_price
3 FROM products;

Harga maksimal 100.00.

Hasil

(prices with maximum cap)

SQL

1 SELECT project,
2   LEAST(start_date, deadline) AS earliest
3 FROM projects;

Tanggal paling awal.

Hasil

(earliest date per project)

1	SELECT project,
2	LEAST(start_date, deadline) AS earliest
3	FROM projects;