array_max

説明

ARRAY 内のすべてのデータの最大値を取得し、この結果を返します。

構文

array_max(array(type))

例

mysql> select array_max([113, 11, 12]);
+------------------------+
| array_max([113,11,12]) |
+------------------------+
| 113                    |
+------------------------+

mysql> select array_max([11.33, 11.11, 12.324]);
+---------------------------------+
| array_max([11.33,11.11,12.324]) |
+---------------------------------+
| 12.324                          |
+---------------------------------+

mysql> select array_max([cast('2020-02-25 11:35:17' as datetime), cast('2019-08-25 17:07:10' as datetime), cast('2025-08-25 17:07:10' as datetime)]);
+--------------------------------------------------------------------------------------------------------------------------------------+
| array_max([CAST('2020-02-25 11:35:17' AS DATETIME),CAST('2019-08-25 17:07:10' AS DATETIME),CAST('2025-08-25 17:07:10' AS DATETIME)]) |
+--------------------------------------------------------------------------------------------------------------------------------------+
| 2025-08-25 17:07:10                                                                                                                  |
+--------------------------------------------------------------------------------------------------------------------------------------+

キーワード

ARRAY_MAX, ARRAY