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 maximumval
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 β
ββββββββββββββββββββββββ