Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

Comparison Functions

  • reference
    +

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

    GREATEST(expression1, expression2, ...)

    Description

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

    Example

    Example 1. Find the largest value from a list of parameterss
    Query
    select GREATEST(30, 20, 26, 12) as biggest
    Result
    [
  {
    "biggest": 30
  }
]

    LEAST(expression1, expression2, ...)

    Description

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

    Example

    Example 2. Find the largest value from a list of parameterss
    Query
    select LEAST(30, 20, 26, 12) as smallest
    Result
    [
  {
    "smallest": 12
  }
]