elasticsearch/docs/reference/esql/functions/min.asciidoc

[discrete]
[[esql-agg-min]]
=== `MIN`

*Syntax*

[source,esql]
----
MIN(expression)
----

*Parameters*

`expression`::
Expression from which to return the minimum value.

*Description*

Returns the minimum value of a numeric expression.

*Example*

[source.merge.styled,esql]
----
include::{esql-specs}/stats.csv-spec[tag=min]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/stats.csv-spec[tag=min-result]
|===

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:

[source.merge.styled,esql]
----
include::{esql-specs}/stats.csv-spec[tag=docsStatsMinNestedExpression]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/stats.csv-spec[tag=docsStatsMinNestedExpression-result]
|===