Help Center/ Data Lake Insight/ SQL Syntax Reference (Paris Region)/ Spark SQL Syntax Reference/ Built-in Functions/ Mathematical Functions/ greatest
Updated on 2025-01-22 GMT+08:00
View PDF
Share

greatest

This function is used to return the greatest value in a list of values.

Syntax

greatest(T v1, T v2, ...)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

v1

Yes

DOUBLE, BIGINT, or DECIMAL

The value can be a float or integer.

v2

Yes

DOUBLE, BIGINT, or DECIMAL

The value can be a float or integer.

Return Values

The return value is of the DOUBLE type.

If the value of a is NULL, NULL is returned.

Example Code

The value 4.0 is returned.

select greatest(1,2.0,3,4.0);

The value NULL is returned.

select greatest(null);
Parent topic: Mathematical Functions