Aggregate Min/Max

Calculates and returns the minimum and maximum values of a particular column in a table.

Input Parameter Description

Name Type Description
table_name string Name of the table on which the operation will be performed. Must be an existing table, in [schema_name.]table_name format, using standard name resolution rules.
column_name string Name of a column or an expression of one or more column on which the min-max will be calculated.
options map of string to strings Optional parameters. The default value is an empty map ( {} ).

Output Parameter Description

Name Type Description
min double Minimum value of the input parameter column_name.
max double Maximum value of the input parameter column_name.
info map of string to strings Additional information.