Skip to main content

argMin

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

Syntax​

argMin(arg, val)

Arguments​

ArgumentsDescription
argArgument
valValue

Return Type​

arg value that corresponds to minimum val value.

matches arg type.

Examples​

note

numbers(N) – A table for test with the single number column (UInt64) that contains integers from 0 to N-1.

Input table:

mysql> SELECT sum(number) AS salary, number%3 AS user FROM numbers_mt(10000) GROUP BY user ORDER BY salary ASC;
+----------+------+
| salary | user |
+----------+------+
| 16661667 | 1 |
| 16665000 | 2 |
| 16668333 | 0 |
+----------+------+
mysql> SELECT argMin(user, salary)  FROM (SELECT sum(number) AS salary, number%3 AS user FROM numbers_mt(10000) GROUP BY user);
+----------------------+
| argMin(user, salary) |
+----------------------+
| 1 |
+----------------------+