Aggregate. Returns the minimum non-NULL value from a group of values.
min ( expression )
expression | An expression that will typically reference one or more columns in the input stream. It will be evaluated using an arbitrary member of the group. |
The returned value is based on the datatype of the input. If all values are NULL, the function returns NULL.
The min function can be used to assess portfolios and identify the lowest stocks in a group of values.