MIN_BY (Lakehouse v2)

Returns the value of one column associated with the minimum value of another column.

Analyze Syntax

func.min_by(get_column(table, 'name'), get_column(table, 'salary'))

Analyze Examples

func.min_by(get_column(table, 'name'), get_column(table, 'salary'))

┌─────┐
│ Bob │
└─────┘

SQL Syntax

MIN_BY(<name>, <salary>)

SQL Examples

SELECT MIN_BY(name, salary) FROM employees;

┌─────┐
│ Bob │
└─────┘