Aggregate

MAX

MySQL

Mengembalikan nilai maksimum dari kolom atau ekspresi. Bekerja dengan tipe data numerik, string, dan tanggal. Mengabaikan nilai NULL.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

MAX([DISTINCT] expr)

expranywajib

Ekspresi yang akan dicari nilai maksimumnya

SQL

1 SELECT MAX(price) AS highest_price FROM products;

Menemukan harga produk paling mahal.

Hasil

highest_price: 1999.99

SQL

1 SELECT MAX(order_date) AS last_order FROM orders;

Menemukan tanggal order paling akhir.

Hasil

last_order: 2024-12-20

SQL

1 SELECT MAX(product_name) AS last_alphabetically
2 FROM products;

Menemukan nama produk terakhir secara alfabetis.

Hasil

last_alphabetically: Zebra Print Shirt

SQL

1 SELECT department, MAX(salary) AS max_salary
2 FROM employees
3 GROUP BY department;

Menemukan gaji tertinggi per departemen.

Hasil

Sales: 95000, Engineering: 150000

1	SELECT MAX(product_name) AS last_alphabetically
2	FROM products;

1	SELECT department, MAX(salary) AS max_salary
2	FROM employees
3	GROUP BY department;