Comparison Functions

  • reference
    +

    Comparison functions determine the greatest or least value from a set of values.

    GREATEST(expression1, expression2, ...)

    Largest non-NULL, non-MISSING value if the values are of the same type; otherwise NULL.

    LEAST(expression1, expression2, ...)

    Returns smallest non-NULL, non-MISSING value if the values are of the same type, otherwise returns NULL.