min

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

Example:

SELECT min(salary) FROM employees;

SELECT department, min(salary) FROM employees GROUP BY department;

If you need non-aggregate function to choose a minimum of two values, see least:

SELECT least(a, b) FROM table;

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