Aggregate

MAX

Snowflake

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

Tipe hasil: Same as input typeDiperbarui: 6 Jan 2026

Syntax

SQL

MAX(expression)

Parameter

expressionanywajib

Kolom atau ekspresi yang akan dicari nilai maksimumnya

Contoh Penggunaan

Mencari Harga Tertinggi

SQL

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

Mencari harga produk tertinggi di kategori Electronics.

Hasil

5000000.00

Mencari Transaksi Terakhir

SQL

1 SELECT MAX(transaction_date) as last_transaction
2 FROM transactions
3 WHERE customer_id = 'CUST-001';

Mencari tanggal transaksi terakhir dari customer tertentu.

Hasil

2024-03-15

MAX dengan Conditional

SQL

1 SELECT
2   product_id,
3   MAX(CASE WHEN region = 'ASIA' THEN sales_amount END) as asia_max,
4   MAX(CASE WHEN region = 'EUROPE' THEN sales_amount END) as europe_max,
5   MAX(CASE WHEN region = 'AMERICAS' THEN sales_amount END) as americas_max
6 FROM sales
7 GROUP BY product_id;

Mencari penjualan maksimum per produk di setiap region menggunakan conditional aggregation.

Hasil

PRODUCT_ID	ASIA_MAX	EUROPE_MAX	AMERICAS_MAX
PROD-001	500000	450000	480000
PROD-002	750000	800000	720000

MAX sebagai Window Function

SQL

1 SELECT
2   employee_id,
3   department,
4   salary,
5   MAX(salary) OVER (PARTITION BY department) as dept_max_salary,
6   salary / MAX(salary) OVER (PARTITION BY department) * 100 as pct_of_max
7 FROM employees
8 ORDER BY department, salary DESC;

Membandingkan gaji karyawan dengan gaji maksimum di departmentnya.

Hasil

EMPLOYEE_ID	DEPARTMENT	SALARY	DEPT_MAX_SALARY	PCT_OF_MAX
E001	Engineering	150000	150000	100.00
E002	Engineering	120000	150000	80.00
E003	Sales	100000	100000	100.00

Fungsi Terkait

COUNTSUMAVGMIN

Kembali ke Snowflake Functions

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

1	SELECT MAX(transaction_date) as last_transaction
2	FROM transactions
3	WHERE customer_id = 'CUST-001';

1	SELECT
2	product_id,
3	MAX(CASE WHEN region = 'ASIA' THEN sales_amount END) as asia_max,
4	MAX(CASE WHEN region = 'EUROPE' THEN sales_amount END) as europe_max,
5	MAX(CASE WHEN region = 'AMERICAS' THEN sales_amount END) as americas_max
6	FROM sales
7	GROUP BY product_id;

1	SELECT
2	employee_id,
3	department,
4	salary,
5	MAX(salary) OVER (PARTITION BY department) as dept_max_salary,
6	salary / MAX(salary) OVER (PARTITION BY department) * 100 as pct_of_max
7	FROM employees
8	ORDER BY department, salary DESC;