min

Introduced in: v1.1.0 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

Query

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

SELECT min(salary) FROM employees;

Response

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

Min with GROUP BY

Query

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;

Response

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

​min

min