Categories:

Conditional expression functions

# LEASTÂ¶

Returns the smallest value from a list of expressions. LEAST supports all data types, including VARIANT.

LEAST_IGNORE_NULLS

## SyntaxÂ¶

```LEAST(( <expr1> [ , <expr2> ... ] )
```

## ArgumentsÂ¶

`exprN`

The arguments must include at least one expression. All the expressions should be of the same type or compatible types.

## ReturnsÂ¶

The first argument determines the return type:

• If the first type is numeric, then the return type is â€˜widenedâ€™ according to the numeric types in the list of all arguments.

• If the first type is not numeric, then all other arguments must be convertible to the first type.

If any argument is NULL, returns NULL.

## Collation detailsÂ¶

• The collation specifications of all input arguments must be compatible.

• The comparisons follow the collation based on the input argumentsâ€™ collations and precedences.

• The collation of the result of the function is the highest-precedence collation of the inputs.

## ExamplesÂ¶

The following examples use the LEAST function:

```SELECT LEAST(1, 3, 0, 4);
```
```+-------------------+
| LEAST(1, 3, 0, 4) |
|-------------------|
|                 0 |
+-------------------+
```
```SELECT col_1,
col_2,
col_3,
LEAST(col_1, col_2, col_3) AS least
FROM (SELECT 1 AS col_1, 2 AS col_2, 3 AS col_3
UNION ALL
SELECT 2, 4, -1
UNION ALL
SELECT 3, 6, NULL);
```
```+-------+-------+-------+-------+
| COL_1 | COL_2 | COL_3 | LEAST |
|-------+-------+-------+-------|
|     1 |     2 |     3 |     1 |
|     2 |     4 |    -1 |    -1 |
|     3 |     6 |  NULL |  NULL |
+-------+-------+-------+-------+
```
Language: English