Aggregate

MIN

MySQL

Mengembalikan nilai minimum dari kolom atau ekspresi. Bekerja dengan tipe data numerik, string, dan tanggal. Mengabaikan nilai NULL.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

MIN([DISTINCT] expr)

expranywajib

Ekspresi yang akan dicari nilai minimumnya

SQL

1 SELECT MIN(price) AS lowest_price FROM products;

Menemukan harga produk paling murah.

Hasil

lowest_price: 9.99

SQL

1 SELECT MIN(order_date) AS first_order FROM orders;

Menemukan tanggal order paling awal.

Hasil

first_order: 2023-01-15

SQL

1 SELECT MIN(product_name) AS first_alphabetically
2 FROM products;

Menemukan nama produk pertama secara alfabetis.

Hasil

first_alphabetically: Apple iPhone

SQL

1 SELECT category, MIN(price) AS min_price
2 FROM products
3 GROUP BY category;

Menemukan harga terendah per kategori produk.

Hasil

Electronics: 29.99, Clothing: 9.99

1	SELECT MIN(product_name) AS first_alphabetically
2	FROM products;

1	SELECT category, MIN(price) AS min_price
2	FROM products
3	GROUP BY category;