greatest()

Returns the highest value of the set of input parameters

Arguments & returns

Scalar

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

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

SELECT greatest(42, 84);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT greatest('abc', 'bcd', 'cde', 'EFG');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT GREATEST_IGNORE_NULLS(1, 2)

In DuckDB

SELECT GREATEST(1, 2)

Used in larger rewrites 1

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

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