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 |