• esProc
Tutorial
Function Reference
Sample Program
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL Command Executor Manual
• YModel
User Reference
JSON-style Parameter Guide
• Official Website

# min()

Here’s how to use min() function.

## A .min()

Description:

Compute the minimum value of all the non-null members in a sequence.

Syntax:

 A.min() Equivalent to min(x1,…,xn)

Note:

The function computes the minimum value of all the non-null members in sequence A. Note that this function doesn’t apply to a sequence whose members are of different data types.

Parameter:

 A A sequence

Option:

@0  Do not ignore null

Return value:

The minimum value of all members in sequence A

Example:

 A 1 =[8,-6,1,3,5].min() -6 2 =["c","b","e","A"].min() "A" 3 =["a",1].min() An error message will be displayed because members are of different data types 4 =["a",null,"b"].min() "a" 5 =min("c","b","e","A") "A"

Related function:

## A .min( x )

Description:

Compute x with each member of the sequence and then find the minimum value of the members of the new sequence

Syntax:

 A.min(x) Equivalent to A.(x).min()

Note:

The function loops through each member of sequence A to compute expression x and return the minimum value of members of the resulting sequence.

Parameter:

 A A sequence x Generally, an expression of a single field name, or a legal expression composed of multiple field names.

Return value:

The minimum value of all members after computations have been performed on sequence A.

Example:

 A 1 =demo.query("select * from EMPLOYEE") 2 =A1.min(SALARY) Compute the lowest non-null value of SALARY 3 =A1.(SALARY+100).min() Add 100 to the salary of each employee and then compute the lowest salary

Related function: