elasticsearch/docs/reference/query-languages/esql/_snippets/functions/max.md

MAX [esql-max]

Syntax

:::{image} ../../../../../images/max.svg :alt: Embedded :class: text-center :::

Parameters

true Description

The maximum value of a field.

Supported types

field	result
boolean	boolean
date	date
date_nanos	date_nanos
double	double
integer	integer
ip	ip
keyword	keyword
long	long
text	keyword
version	version

Examples

FROM employees
| STATS MAX(languages)

MAX(languages):integer
5

The expression can use inline functions. For example, to calculate the maximum over an average of a multivalued column, use MV_AVG to first average the multiple values per row, and use the result with the MAX function

FROM employees
| STATS max_avg_salary_change = MAX(MV_AVG(salary_change))

max_avg_salary_change:double
13.75