Aggregate

MIN

Snowflake

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

Tipe hasil: Same as input typeDiperbarui: 6 Jan 2026

Syntax

SQL

MIN(expression)

Parameter

expressionanywajib

Kolom atau ekspresi yang akan dicari nilai minimumnya

Contoh Penggunaan

Mencari Harga Terendah

SQL

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

Mencari harga produk terendah di kategori Electronics.

Hasil

150000.00

Mencari Tanggal Pertama

SQL

1 SELECT MIN(order_date) as first_order
2 FROM orders
3 WHERE customer_id = 'CUST-001';

Mencari tanggal order pertama dari customer tertentu.

Hasil

2023-01-15

MIN per Grup

SQL

1 SELECT
2   category,
3   MIN(price) as min_price,
4   MAX(price) as max_price,
5   MAX(price) - MIN(price) as price_range
6 FROM products
7 GROUP BY category
8 ORDER BY price_range DESC;

Mencari harga terendah dan tertinggi per kategori, plus range-nya.

Hasil

CATEGORY	MIN_PRICE	MAX_PRICE	PRICE_RANGE
Electronics	150000	5000000	4850000
Furniture	500000	3000000	2500000
Clothing	50000	1000000	950000

MIN dengan String

SQL

1 SELECT
2   department,
3   MIN(employee_name) as first_alphabetically
4 FROM employees
5 GROUP BY department;

Mencari nama karyawan pertama secara alfabetis per department.

Hasil

DEPARTMENT	FIRST_ALPHABETICALLY
Sales	Adam Smith
Engineering	Alice Johnson
Marketing	Bob Williams

Fungsi Terkait

COUNTSUMAVGMAX

Kembali ke Snowflake Functions

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

1	SELECT MIN(order_date) as first_order
2	FROM orders
3	WHERE customer_id = 'CUST-001';

1	SELECT
2	category,
3	MIN(price) as min_price,
4	MAX(price) as max_price,
5	MAX(price) - MIN(price) as price_range
6	FROM products
7	GROUP BY category
8	ORDER BY price_range DESC;

1	SELECT
2	department,
3	MIN(employee_name) as first_alphabetically
4	FROM employees
5	GROUP BY department;