Conditional

LEAST

DuckDB

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

Tipe hasil: Tipe dari nilai terkecilDiperbarui: 6 Jan 2026

Syntax

SQL

LEAST(value1, value2, ...)

Parameter

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

Nilai-nilai yang akan dibandingkan

Contoh Penggunaan

Nilai Terkecil

SQL

1 SELECT LEAST(10, 20, 5, 15) AS min_value;

Mencari nilai terkecil.

Hasil

Capping Values

SQL

1 SELECT
2   product_name,
3   LEAST(quantity * price, 1000) AS capped_total
4 FROM orders;

Total maksimal 1000 (capped).

Earliest Date

SQL

1 SELECT
2   project_name,
3   LEAST(start_date, deadline, CURRENT_DATE) AS earliest
4 FROM projects;

Mencari tanggal paling awal.

GREATEST dan LEAST Combination

SQL

1 -- Clamp value between min and max
2 SELECT
3   value,
4   GREATEST(LEAST(value, 100), 0) AS clamped
5 FROM data;
6 -- Result: value between 0 and 100

Membatasi nilai dalam range 0-100.

Fungsi Terkait

GREATEST

Kembali ke DuckDB Functions

1	SELECT
2	product_name,
3	LEAST(quantity * price, 1000) AS capped_total
4	FROM orders;

1	SELECT
2	project_name,
3	LEAST(start_date, deadline, CURRENT_DATE) AS earliest
4	FROM projects;

1	-- Clamp value between min and max
2	SELECT
3	value,
4	GREATEST(LEAST(value, 100), 0) AS clamped
5	FROM data;
6	-- Result: value between 0 and 100