Aggregate

MIN

DuckDB

Mengembalikan nilai minimum dari sebuah kolom. Bisa digunakan untuk tipe data numerik, string, date, dan timestamp.

Tipe hasil: Sama dengan tipe inputDiperbarui: 6 Jan 2026

Syntax

SQL

MIN(expression)

expressionany comparablewajib

Kolom atau ekspresi yang akan dicari nilai minimumnya

SQL

1 SELECT MIN(price) as lowest_price
2 FROM products
3 WHERE category = 'Electronics';

Mencari harga produk elektronik paling murah.

Hasil

150000

SQL

1 SELECT
2   category,
3   MIN(price) as min_price,
4   MAX(price) as max_price
5 FROM products
6 GROUP BY category;

Mencari range harga (min dan max) per kategori.

Hasil

SQL

1 SELECT
2   customer_id,
3   MIN(order_date) as first_order,
4   MAX(order_date) as last_order
5 FROM orders
6 GROUP BY customer_id;

Mencari tanggal order pertama dan terakhir per customer.

Hasil

customer_id	first_order	last_order
1	2023-01-15	2024-03-10
2	2023-03-22	2024-02-28

1	SELECT MIN(price) as lowest_price
2	FROM products
3	WHERE category = 'Electronics';