Categories: Aggregate, Window

MIN

Returns the minimum value for 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.