Categories: Aggregate, Window

MAX

Returns the maximum value for the non-NULL input expressions.

Syntax

MAX(expression float) → float

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression boolean) → boolean

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression varchar) → varchar

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

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

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression double) → double

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression interval_day) → interval_day

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression int64) → int64

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression date) → date

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression int32) → int32

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression interval_year) → interval_year

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression varbinary) → varbinary

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression time) → time

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.

MAX(expression timestamp) → timestamp

  • expression: Input expression.

Examples

SELECT MAX(column_name)
-- Max of the values in the specified column.