Aggregate

ARG_MAX

DuckDB

Mengembalikan nilai 'arg' yang berkorespondensi dengan nilai maksimum dari 'val'. Kebalikan dari ARG_MIN.

Tipe hasil: Sama dengan tipe argDiperbarui: 6 Jan 2026

Syntax

SQL

ARG_MAX(arg, val)

Parameter

arganywajib

Kolom yang nilainya akan dikembalikan

valany comparablewajib

Kolom yang akan dicari nilai maksimumnya

Contoh Penggunaan

Produk Termahal per Kategori

SQL

1 SELECT
2   category,
3   ARG_MAX(name, price) as expensive_product,
4   MAX(price) as highest_price
5 FROM products
6 GROUP BY category;

Mendapatkan nama produk termahal dan harganya per kategori.

Hasil

category	expensive_product	highest_price
Electronics	MacBook Pro	25000000
Clothing	Designer Jacket	5000000
Books	Encyclopedia Set	2500000

Top Performer per Department

SQL

1 SELECT
2   department,
3   ARG_MAX(name, sales_amount) as top_performer,
4   MAX(sales_amount) as highest_sales
5 FROM employees
6 GROUP BY department;

Mencari sales dengan penjualan tertinggi per department.

Hasil

department	top_performer	highest_sales
Sales	Ahmad	500000000
Marketing	Budi	350000000

Fungsi Terkait

ANY_VALUEFIRSTLASTARG_MIN

Kembali ke DuckDB Functions

1	SELECT
2	category,
3	ARG_MAX(name, price) as expensive_product,
4	MAX(price) as highest_price
5	FROM products
6	GROUP BY category;

1	SELECT
2	department,
3	ARG_MAX(name, sales_amount) as top_performer,
4	MAX(sales_amount) as highest_sales
5	FROM employees
6	GROUP BY department;