MAX (Lakehouse v2)

Returns the maximum value in a set of values.

Analyze Syntax

func.max(get_column(table, 'salary'))

Analyze Examples

func.max(get_column(table, 'salary'))

┌────────┐
│ 150000 │
└────────┘

SQL Syntax

MAX(<salary>)

SQL Examples

SELECT MAX(salary) FROM employees;

┌────────┐
│ 150000 │
└────────┘