---
title: ES|QL LEAST function
description: 
url: https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/conditional-functions-and-expressions/least
products:
  - Elasticsearch
---

# ES|QL LEAST function
## Syntax

![Embedded](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/images/functions/least.svg)


## Parameters

<definitions>
  <definition term="first">
    First of the columns to evaluate.
  </definition>
  <definition term="rest">
    The rest of the columns to evaluate.
  </definition>
</definitions>


## Description

Returns the minimum value from multiple columns. This is similar to [`MV_MIN`](https://www.elastic.co/elastic/docs-builder/docs/3028/reference/query-languages/esql/functions-operators/mv-functions/mv_min) except it is intended to run on multiple columns at once.

## Supported types


| first      | rest       | result     |
|------------|------------|------------|
| boolean    | boolean    | boolean    |
| boolean    |            | boolean    |
| date       | date       | date       |
| date_nanos | date_nanos | date_nanos |
| double     | double     | double     |
| integer    | integer    | integer    |
| integer    |            | integer    |
| ip         | ip         | ip         |
| keyword    | keyword    | keyword    |
| keyword    |            | keyword    |
| long       | long       | long       |
| long       |            | long       |
| text       | text       | keyword    |
| text       |            | keyword    |
| version    | version    | version    |


## Example

```esql
ROW a = 10, b = 20
| EVAL l = LEAST(a, b)
```


| a:integer | b:integer | l:integer |
|-----------|-----------|-----------|
| 10        | 20        | 10        |