<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Aggregate Functions >


Previous pageReturn to chapter overviewNext page

MIN ( [DISTINCT | ALL] <value-expression> ) [ OVER <window-specification> ]


MIN returns the minimum value of all the value expressions evaluated for each row in the aggregation. When used without the OVER clause, MIN is considered an aggregate function. When used with the OVER clause, it is an analytic function.

For string values, MIN is determined by which string is first in the collating sequence.

When used as an analytic function, MIN will return null if the window being evaluated (or in the case of a PARTITION BY, the partition within the window matching the input row) contains no rows.