Functions/Database & utility/greatest
Database & utility Scalar

greatest()

Returns the largest value. For strings lexicographical ordering is used. Note that lowercase characters are considered “larger” than uppercase characters and collations are not supported.

Arguments & returns

greatest(arg1, …)

Scalar
Overload link arg1 … Varargs Returns
#01 ANY ANY ANY

… accepts a variable number of arguments of the type shown.

Example

1 more ↓
greatest example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

greatest example 2
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Snowflakegreatest_ignore_nulls()

SELECT GREATEST_IGNORE_NULLS(1, 2)
In DuckDB
SELECT GREATEST(1, 2)

SQLGlot example ↗

Used in larger rewrites 1

These examples use greatest as one part of a larger SQL translation.

BigQuerygreatest()

SELECT GREATEST(1, NULL, 3)
In DuckDB
SELECT CASE WHEN 1 IS NULL OR NULL IS NULL OR 3 IS NULL THEN NULL ELSE GREATEST(1, NULL, 3) END

SQLGlot example ↗