--- title: experimental.min() function description: > The `experimental.min()` function returns the record with the lowest value in the `_value` column for each input table. menu: flux_0_x_ref: name: experimental.min parent: experimental weight: 302 aliases: - /influxdb/v2.0/reference/flux/stdlib/experimental/min/ - /influxdb/cloud/reference/flux/stdlib/experimental/min/ related: - /{{< latest "influxdb" >}}/flux/stdlib/built-in/transformations/selectors/min/ - /{{< latest "influxdb" "v1" >}}/query_language/functions/#min, InfluxQL – MIN() flux/v0.x/tags: [transformations, selectors] introduced: 0.112.0 --- The `experimental.min()` function returns the record with the lowest value in the `_value` column for each input table. _`experimental.min()` is a [selector function](/flux/v0.x/function-types/#selectors)._ ```js import "experimental" experimental.min() ``` {{% warn %}} #### Empty tables `experimental.min()` drops empty tables. {{% /warn %}} ## Parameters ### tables {data-type="stream of tables"} Input data. Default is piped-forward data (`<-`). ## Examples ```js import "experimental" data |> experimental.min() ``` {{< flex >}} {{% flex-content %}} ##### Input data | _time | _value | |:----- | ------:| | 2021-01-01T00:00:00Z | 1.2 | | 2021-01-01T00:01:00Z | 0.6 | | 2021-01-01T00:02:00Z | 2.3 | | 2021-01-01T00:03:00Z | 0.9 | {{% /flex-content %}} {{% flex-content %}} ##### Output data | _time | _value | |:----- | ------:| | 2021-01-01T00:01:00Z | 0.6 | {{% /flex-content %}} {{< /flex >}}