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

# min()

Description:

find the minimum value among members of a sequence.

Syntax:

 A.min(x) min(x1,…,xn) Equivalent to A.min(), where x1,…,xn are members of sequence A

Note:

The function computes expression x with members of sequence A and by default, returns the minimum non-null value.

Parameter:

 A A sequence, where members should have same data type x An expression; cannot be omitted when sequence A is a table sequence or a record sequence

Option:

 @0 Do not ignore null members; syntax min(x1,…,xn) isn’t supported when this option works

Return value:

The minimum value

Example:

When A is a sequence:

 A 1 =["c","b","e","A"].min() "A" 2 =[8,-6,1,3,5].min(~*2) -12 3 =["a",1].min() Error is reported as members of the sequence have inconsistent data types. 4 =["a",null,"b"].min() "a"; ignore null members. 5 =["a",null,"b"].min@0() null. 6 =min("c","b","e","A") "A", which is same as A1.

When A is a table sequence or a record sequence:

 A 1 =demo.query("select EID,NAME,SALARY from EMPLOYEE").sort(SALARY) Query content of EMPLOYEE table and sort result by SALARY in ascending order. 2 =A1.min(SALARY+1000) Get the lowest SALARY value after salary is increased by 1000 and return 4000. 3 =demo.query("select * from AREA") Query AREA table. 4 =A3.min(FATHER) Get the minimum non-null FATHER value in AREA table and return 0.