min

Introduced in: v1.1

Aggregate function that calculates the minimum across a group of values.

Syntax

min(column)

Arguments

column — Column name or expression. Any

Returned value

Returns the minimum value across the group with type equal to that of the input. Any

Examples

Simple min example

CREATE TABLE employees (name String, salary UInt32) ENGINE = Memory;
INSERT INTO employees VALUES ('Alice', 3000), ('Bob', 4000), ('Charlie', 3500);

SELECT min(salary) FROM employees;

┌─min(salary)─┐
│        3000 │
└─────────────┘

Min with GROUP BY

CREATE TABLE sales (department String, revenue UInt32) ENGINE = Memory;
INSERT INTO sales VALUES ('Engineering', 100000), ('Engineering', 120000), ('Marketing', 80000), ('Marketing', 90000);

SELECT department, min(revenue) FROM sales GROUP BY department ORDER BY department;

┌─department──┬─min(revenue)─┐
│ Engineering │       100000 │
│ Marketing   │        80000 │
└─────────────┴──────────────┘

min​

min