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, ...)

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.