GREATEST
Descriptionβ
Compares multiple expressions and returns the greatest value among them. If any argument is NULL
, the function returns NULL
.
Syntaxβ
GREATEST(<expr> [, ...])
Parametersβ
Parameter | Description |
---|---|
<expr> | A list of expressions to compare. Supports TINYINT , SMALLINT , INT , BIGINT , LARGEINT , FLOAT , DOUBLE , STRING , DATETIME , and DECIMAL types. |
Return Valueβ
- Returns the largest value among the given expressions.
- If any argument is
NULL
, returnsNULL
.
Examplesβ
SELECT GREATEST(-1, 0, 5, 8);
+-----------------------+
| GREATEST(-1, 0, 5, 8) |
+-----------------------+
| 8 |
+-----------------------+
SELECT GREATEST(-1, 0, 5, NULL);
+--------------------------+
| GREATEST(-1, 0, 5, NULL) |
+--------------------------+
| NULL |
+--------------------------+
SELECT GREATEST(6.3, 4.29, 7.6876);
+-----------------------------+
| GREATEST(6.3, 4.29, 7.6876) |
+-----------------------------+
| 7.6876 |
+-----------------------------+
SELECT GREATEST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22 20:02:11');
+-------------------------------------------------------------------------------+
| GREATEST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22 20:02:11') |
+-------------------------------------------------------------------------------+
| 2022-02-26 20:02:11 |
+-------------------------------------------------------------------------------+