Skip to main content

argMax

Calculates the arg value for a maximum val value. If there are several different values of arg for maximum values of val, returns the first of these values encountered.

Syntax

argMax(arg, val)

Arguments

  • arg β€” Argument.
  • val β€” Value.

Returned value

  • arg value that corresponds to maximum val value.

Type: matches arg type.

Example

Input table:

β”Œβ”€user─────┬─salary─┐
β”‚ director β”‚ 5000 β”‚
β”‚ manager β”‚ 3000 β”‚
β”‚ worker β”‚ 1000 β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”˜

Query:

SELECT argMax(user, salary) FROM salary;

Result:

β”Œβ”€argMax(user, salary)─┐
β”‚ director β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜