greatest function

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the greatest value of all arguments, skipping null values.

Syntax

greatest(expr1, expr2 [, ...])

Arguments

  • exprN: Any expression of a comparable type with a shared least common type across all exprN.

Returns

The result type is the least common type of the arguments.

Examples

> SELECT greatest(10, 9, 2, 4, 3);
 10

> DESCRIBE SELECT greatest(10, 9e2, 2.2) AS greatest;
 greatest  double