• 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

# max()

Description:

Find the maximum value among members of a sequence.

Syntax:

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

Note:

The function computes expression x with members of sequence A and returns the maximum member value.

Parameter:

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

Return value:

The maximum value

Example:

When A is a sequence:

 A 1 =[8,-6,1,3,5].max() 8. 2 =["c","b",null,"e","A"].max() "e". 3 =["a",1].max() Error is reported as members of the sequence have inconsistent data types. 4 =[8,-6,1,3,5].max(~*10) 80; return the maximum member value after expression is computed. 5 =max(8,-6,1,3,5) 8; 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:-1) Query content of EMPLOYEE table and sort result by SALARY in descending order. 2 =A1.max(SALARY+1000) Get the highest SALARY value after salary is increased by 1000 and return 17,000.