min

Contents

min#

min(input)[source]#

Finds the minimum value among non-null elements in the input expression.

Example:

SQL#
SELECT min(x) FROM tbl
Input#
╭───────╮
│ x     │
│ ---   │
│ Int64 │
╞═══════╡
│ 100   │
├╌╌╌╌╌╌╌┤
│ 200   │
├╌╌╌╌╌╌╌┤
│ null  │
╰───────╯
(Showing first 3 of 3 rows)
Output#
╭───────╮
│ x     │
│ ---   │
│ Int64 │
╞═══════╡
│ 100   │
╰───────╯
(Showing first 1 of 1 rows)