MAX_BY
Returns the value of one column associated with the maximum value of another column.
Analyze Syntax
func.max_by(get_column(table, 'name'), get_column(table, 'salary'))
Analyze Examples
func.max_by(get_column(table, 'name'), get_column(table, 'salary'))
┌───────┐
│ Alice │
└───────┘
SQL Syntax
MAX_BY(<name>, <salary>)
SQL Examples
SELECT MAX_BY(name, salary) FROM employees;
┌───────┐
│ Alice │
└───────┘