Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

5.2 KiB

Raw Permalink Blame History

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

5.2 KiB Raw Permalink Blame History