Categories: Aggregate, Window

MIN

Returns the minimum value among the non-NULL input expressions.

Syntax

MIN(expression time) → time

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression decimal(0,0)) → double

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression date) → date

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression int64) → int64

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression double) → double

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression boolean) → boolean

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression float) → float

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression interval_year) → interval_year

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression interval_day) → interval_day

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression varbinary) → varbinary

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression varchar) → varchar

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression int32) → int32

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.

MIN(expression timestamp) → timestamp

• expression: Input expression.

Examples

SELECT MIN(column_name)
-- Min of the values in the specified column.