Skip to main content
Skip to main content

ARRAY_MIN

array_min​

array_min

description​

Syntax​

T array_min(ARRAY<T> array1)

Get the minimum element in an array (NULL values are skipped). When the array is empty or all elements in the array are NULL values, the function returns NULL.

example​

mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
-> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2, 3]), (3, [1, NULL, 3]);
mysql> select k2, array_min(k2) from array_type_table;
+--------------+-----------------+
| k2 | array_min(`k2`) |
+--------------+-----------------+
| [] | NULL |
| [NULL] | NULL |
| [1, 2, 3] | 1 |
| [1, NULL, 3] | 1 |
+--------------+-----------------+
4 rows in set (0.02 sec)

keywords​

ARRAY,MIN,ARRAY_MIN