min() (aggregation function)

Returns the minimum value across the group.

  • Can be used only in context of aggregation inside summarize

Syntax

summarize min(Expr)

Arguments

  • Expr: Expression that will be used for aggregation calculation.

Returns

The minimum value of Expr across the group.

Tip

This gives you the min or max on its own - for example, the highest or lowest price. But if you want other columns in the row - for example, the name of the supplier with the lowest price - use arg_max or arg_min.