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
March 9, 2025
+ 12

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
sql++
Copy
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
sql++
Copy
select LEAST(30, 20, 26, 12) as smallest
Result
[
  {
    "smallest": 12
  }
]