Conditional

LEAST

PostgreSQL

Mengembalikan nilai terkecil dari daftar nilai. Mengabaikan NULL values kecuali semua NULL. Kebalikan dari GREATEST.

Tipe hasil: same as input

Syntax

SQL

LEAST(value1, value2, ...)

valuesany comparablewajib

Daftar nilai yang akan dibandingkan

SQL

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

Mencari nilai terkecil dari list.

Hasil

least
5

SQL

1 SELECT 
2   product_name,
3   LEAST(price_online, price_store, price_wholesale) AS min_price
4 FROM products;

Mencari harga terendah dari berbagai channel.

Hasil

product_name	min_price
Laptop	1200000

SQL

1 SELECT 
2   user_id,
3   download_count,
4   LEAST(download_count, 100) AS capped_downloads
5 FROM user_stats;

Membatasi nilai maksimum (capping).

Hasil

user_id	download_count	capped_downloads
1	50	50
2	150	100

LEAST

MySQL

LEAST

BigQuery

LEAST

DuckDB

1	SELECT
2	product_name,
3	LEAST(price_online, price_store, price_wholesale) AS min_price
4	FROM products;

1	SELECT
2	user_id,
3	download_count,
4	LEAST(download_count, 100) AS capped_downloads
5	FROM user_stats;