Aggregate

MAX

DuckDB

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

Tipe hasil: Sama dengan tipe inputDiperbarui: 6 Jan 2026

Syntax

SQL

MAX(expression)

Parameter

expressionany comparablewajib

Kolom atau ekspresi yang akan dicari nilai maksimumnya

Contoh Penggunaan

Mencari Nilai Tertinggi

SQL

1 SELECT MAX(salary) as highest_salary
2 FROM employees;

Mencari gaji tertinggi dari semua karyawan.

Hasil

75000000

MAX dengan FILTER

SQL

1 SELECT
2   MAX(score) as overall_max,
3   MAX(score) FILTER (WHERE subject = 'Math') as max_math,
4   MAX(score) FILTER (WHERE subject = 'Science') as max_science
5 FROM exam_results;

Mencari nilai maksimum keseluruhan dan per mata pelajaran.

Hasil

overall_max	max_math	max_science
100	98	100

Kombinasi MIN dan MAX untuk Range

SQL

1 SELECT
2   DATE_TRUNC('month', order_date) as month,
3   MIN(total_amount) as min_order,
4   MAX(total_amount) as max_order,
5   MAX(total_amount) - MIN(total_amount) as order_range
6 FROM orders
7 GROUP BY DATE_TRUNC('month', order_date)
8 ORDER BY month;

Menganalisis range nilai order per bulan.

Hasil

month	min_order	max_order	order_range
2024-01-01	50000	15000000	14950000
2024-02-01	75000	12500000	12425000

Fungsi Terkait

COUNTSUMAVGMIN

Kembali ke DuckDB Functions

1	SELECT
2	MAX(score) as overall_max,
3	MAX(score) FILTER (WHERE subject = 'Math') as max_math,
4	MAX(score) FILTER (WHERE subject = 'Science') as max_science
5	FROM exam_results;

1	SELECT
2	DATE_TRUNC('month', order_date) as month,
3	MIN(total_amount) as min_order,
4	MAX(total_amount) as max_order,
5	MAX(total_amount) - MIN(total_amount) as order_range
6	FROM orders
7	GROUP BY DATE_TRUNC('month', order_date)
8	ORDER BY month;