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 d

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-aggregation-functions https://www.kinetica.com/docs/concepts/sql.html#sql-aggregat...