GREATEST

The GREATEST function selects the largest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result. NULL values in the argument list are ignored. The result will be NULL only if all the expressions evaluate to NULL.

Syntax

GREATEST(<expression> [,...])

Parameters

Parameter	Description	Supported input types
`<expression>`	The expression(s) to select greatest value.	Any

Return Types

Same as input type

Example

SELECT GREATEST(NULL, 2^3, 3^2);

greatest double null
9

Rows: 1Execution time: 5.91ms

COALESCE

HASH

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Types

Example

​Syntax

​Parameters

​Return Types

​Example

Syntax

Parameters

Return Types

Example