argMin

Syntax: argMin(arg, val)

Calculates the arg value for a minimal val value. If there are several different values of arg for minimal values of val, the first of these values encountered is output.

Example:

  1. ┌─user─────┬─salary─┐
  2. │ director │   5000 │
  3. │ manager  │   3000 │
  4. │ worker   │   1000 │
  5. └──────────┴────────┘
  1. SELECT argMin(user, salary) FROM salary
  1. ┌─argMin(user, salary)─┐
  2. │ worker               │
  3. └──────────────────────┘