Aggregate

MAX

PostgreSQL

Mengembalikan nilai terbesar dari sekumpulan nilai. Bisa digunakan sebagai aggregate function dengan GROUP BY atau sebagai window function.

Tipe hasil: same as input

Syntax

SQL

MAX(expression)
MAX(expression) OVER (window_specification)

expressionany orderablewajib

Kolom atau ekspresi yang akan dicari nilai maksimumnya

SQL

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

Mencari gaji tertinggi dari semua karyawan.

Hasil

highest_salary
25000000

SQL

1 SELECT 
2   department,
3   MAX(salary) AS max_salary,
4   MAX(hire_date) AS latest_hire
5 FROM employees
6 GROUP BY department;

Mencari nilai maksimum per departemen.

Hasil

department	max_salary	latest_hire
Engineering	25000000	2024-06-15
Sales	18000000	2024-08-01

SQL

1 SELECT 
2   date,
3   revenue,
4   MAX(revenue) OVER (ORDER BY date) AS running_max
5 FROM daily_sales;

Menghitung running maximum revenue sampai tanggal tersebut.

MAX

MySQL

MAX

Snowflake

MAX

BigQuery

MAX

DuckDB

1	SELECT
2	date,
3	revenue,
4	MAX(revenue) OVER (ORDER BY date) AS running_max
5	FROM daily_sales;