你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
min() (aggregation function)
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Finds the minimum value across the group.
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 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. 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.
StormEvents
| summarize FirstEvent=min(StartTime)
Output
FirstEvent |
---|
2007-01-01T00:00:00Z |