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, returns NULL.

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                                                           |
+-------------------------------------------------------------------------------+

COALESCE IF