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. |
