max#
- max(input)[source]#
Finds the maximum value among non-null elements in the input expression.
Example:
SQL#SELECT max(x) FROM tbl
Input#╭───────╮ │ x │ │ --- │ │ Int64 │ ╞═══════╡ │ 100 │ ├╌╌╌╌╌╌╌┤ │ 200 │ ├╌╌╌╌╌╌╌┤ │ null │ ╰───────╯ (Showing first 3 of 3 rows)
Output#╭───────╮ │ x │ │ --- │ │ Int64 │ ╞═══════╡ │ 200 │ ╰───────╯ (Showing first 1 of 1 rows)