Feedback Edit

min() (aggregation function)

  • Article
  • 2 minutes to read

Finds the minimum value across the group.

Note

This function is used in conjunction with the summarize operator.

Syntax

min (Expr)

Arguments

Name Type Required Description
Expr string ✓ Expression used for 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.

[Click to run query]

StormEvents
| summarize FirstEvent=min(StartTime)

Results

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