Skip to main content

LEAST

Categories: Conditional

LEAST

Returns the smallest value from a list of expressions.

Syntax

LEAST(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

LEAST example
SELECT LEAST(1, 5, 3, 8)
-- 1