> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/conditional-and-miscellaneous/least",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for LEAST function

# LEAST

The LEAST function selects the smallest value from a list of any number of expressions.
The expressions must all be convertible to a common data type, which will be the type of the result.
NULL values in the argument list are ignored. The result will be NULL only if all the expressions evaluate to NULL.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
LEAST(<expression> [,...])
```

## Parameters

| Parameter      | Description                                 | Supported input types |
| :------------- | :------------------------------------------ | :-------------------- |
| `<expression>` | The expression(s) to select smallest value. | Any                   |

## Return Types

Same as input type

## Example

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT LEAST(NULL, 2^3, 3^2)
```

**Returns:** `8`