min() (aggregation function)

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Finds the minimum value of the expression in the table.

Note

This function is used in conjunction with the summarize operator.

Syntax

min (expr)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
expr	string	✔️	The expression for which the minimum value is determined.

Returns

Returns the minimum value of expr across the table.

Tip

This gives you the min on its own. If you want to see other columns in addition to the min, use arg_min.

Example

This example returns the first record in a table.

Run the query

StormEvents
| summarize FirstEvent=min(StartTime)

Output

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

Related content

• arg_min function
• max function
• avg function
• percentile function
• min-of function