min() (aggregation function)

Finds the minimum value across the group.

Note

This function is used in conjunction with the summarize operator.

Syntax

min (expr)

Parameters

Name Type Required Description
expr string The expression used for the minimum value aggregation calculation.

Returns

Returns the minimum value of expr across the group.

Tip

This gives you the min on its own. But if you want other columns in the row arg_min.

Example

This example returns the first record in a table.

StormEvents
| summarize FirstEvent=min(StartTime)

Output

FirstEvent
2007-01-01T00:00:00Z