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

# ES|QL MIN function
## Syntax

![Embedded](https://www.elastic.co/elastic/docs-builder/docs/2831/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 since 9.3</applies-to>     | double        |
| integer                                                                             | integer       |
| ip                                                                                  | ip            |
| keyword                                                                             | keyword       |
| long                                                                                | long          |
| tdigest <applies-to>Elastic Stack: Preview since 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                        |