---
title: ES|QL MIN function
description: 
url: https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/aggregation-functions/min
products:
  - Elasticsearch
---

# ES|QL MIN function
## Syntax

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


## Parameters

<definitions>
  <definition term="field">
  </definition>
</definitions>


## Description

The minimum value of a field.

## Supported types


| field                                                                               | result        |
|-------------------------------------------------------------------------------------|---------------|
| aggregate_metric_double                                                             | double        |
| boolean                                                                             | boolean       |
| date                                                                                | date          |
| date_nanos                                                                          | date_nanos    |
| double                                                                              | double        |
| exponential_histogram <applies-to>Elastic Stack: Preview in 9.3</applies-to>        | double        |
| integer                                                                             | integer       |
| ip                                                                                  | ip            |
| keyword                                                                             | keyword       |
| long                                                                                | long          |
| tdigest <applies-to>Elastic Stack: Preview in 9.3</applies-to>                      | double        |
| text                                                                                | keyword       |
| unsigned_long <applies-to>Elastic Stack: Generally available since 9.2</applies-to> | unsigned_long |
| version                                                                             | version       |


## Examples

```esql
FROM employees
| STATS MIN(languages)
```


| MIN(languages):integer |
|------------------------|
| 1                      |

The expression can use inline functions. For example, to calculate the minimum over an average of a multivalued column, use `MV_AVG` to first average the multiple values per row, and use the result with the `MIN` function
```esql
FROM employees
| STATS min_avg_salary_change = MIN(MV_AVG(salary_change))
```


| min_avg_salary_change:double |
|------------------------------|
| -8.46                        |

`MIN` can also operate on `exponential_histogram` fields, returning the minimum of the values which were used to construct the histograms.
```esql
TS exp_histo_sample
| WHERE instance == "instance-0"
| STATS minimum = ROUND(MIN(responseTime), 4)
```


| minimum:double |
|----------------|
| 2.0E-4         |

`MIN` can also operate on `tdigest` and casted `histogram` fields, returning the minimum of the values which were used to construct the digests.
```esql
TS histogram_timeseries_index
| WHERE instance == "instance-0"
| STATS minimum = ROUND(MIN(responseTime::tdigest), 4)
```


| minimum:double |
|----------------|
| 2.0E-4         |