[kinetica_engr]

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

https://www.kinetica.com/docs/concepts/sql.html#sql-aggregat...