Aggregate

MIN

BigQuery

Mengembalikan nilai minimum dari sebuah kolom atau ekspresi. Mendukung tipe numerik, string, date/time, dan boolean di BigQuery.

Tipe hasil: Sama dengan tipe inputDiperbarui: 7 Jan 2026

Syntax

SQL

MIN(expression)

Parameter

expressionanywajib

Kolom atau ekspresi yang akan dicari nilai minimumnya. Mendukung INT64, FLOAT64, STRING, DATE, TIMESTAMP, dll.

Contoh Penggunaan

Nilai Minimum Sederhana

SQL

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

Mencari harga terendah produk elektronik.

Hasil

99000

MIN dengan GROUP BY

SQL

1 SELECT
2   product_category,
3   MIN(price) as min_price,
4   MAX(price) as max_price
5 FROM `project.dataset.products`
6 GROUP BY product_category;

Mencari range harga (min-max) per kategori produk.

Hasil

product_category	min_price	max_price
Electronics	99000	25000000
Fashion	50000	5000000
Books	25000	500000

MIN pada Tanggal

SQL

1 SELECT
2   customer_id,
3   MIN(order_date) as first_order_date,
4   MAX(order_date) as last_order_date
5 FROM `project.dataset.orders`
6 GROUP BY customer_id
7 LIMIT 5;

Mencari tanggal order pertama dan terakhir per customer.

Hasil

customer_id	first_order_date	last_order_date
C001	2023-01-15	2024-06-20
C002	2023-03-22	2024-05-18
C003	2022-11-08	2024-06-25

MIN dengan STRUCT

SQL

1 SELECT
2   MIN(STRUCT(price, product_name)) as cheapest_product
3 FROM `project.dataset.products`;

Mencari produk termurah dengan nama produknya menggunakan STRUCT.

Hasil

cheapest_product
{price: 25000, product_name: "Basic Notebook"}

Fungsi Terkait

COUNTSUMAVGMAX

Kembali ke BigQuery Functions

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

1	SELECT
2	product_category,
3	MIN(price) as min_price,
4	MAX(price) as max_price
5	FROM `project.dataset.products`
6	GROUP BY product_category;

1	SELECT
2	customer_id,
3	MIN(order_date) as first_order_date,
4	MAX(order_date) as last_order_date
5	FROM `project.dataset.orders`
6	GROUP BY customer_id
7	LIMIT 5;

1	SELECT
2	MIN(STRUCT(price, product_name)) as cheapest_product
3	FROM `project.dataset.products`;