GREATEST
Categories: Conditional
GREATEST
Returns the largest value from a list of expressions.
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
{{< codeheader "GREATEST example" >}}
SELECT GREATEST(1, 5, 3, 8)
-- 8