With Kinetica you can use the 'arg_max' aggregate function select department, max(gross_salary), arg_max(gross_salary, first_name) from salary group by department…
With Kinetica you can use the 'arg_max' aggregate function select department, max(gross_salary), arg_max(gross_salary, first_name) from salary group by department…