greatest.md

description
Returns the largest value from a list of expressions.

GREATEST

Syntax

GREATEST(expression) → same as input type

• expression: The arguments must include at least one expression. All the expressions should be of the same type or compatible types. Expressions must be of primitive data types.

Examples

{% code title="GREATEST example" %}

SELECT GREATEST(1, 5, 3, 8)
-- 8

{% endcode %}