Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Spark SQL Syntax Reference (Unavailable Soon)> Built-in Functions> Mathematical Functions> least
Updated on 2023-10-25 GMT+08:00
View PDF

least

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

Syntax

least(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 v1 or v2 is of the STRING type, an error is reported.
  • If the values of all parameters are NULL, NULL is returned.

Example Code

The value 1.0 is returned.

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

The value NULL is returned.

select least(null);
Parent topic: Mathematical Functions