A .max( x )

Read(171) Label: compute, maximum value,

Description:

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

Syntax:

A.max(x)

Equivalent to A.(x).max()

Note:

The function loops through members of sequence A and returns the maximum value among members of the new sequence.

Parameters:

A

A sequence

x

Generally an expression of a single field name, or a legal expression composed of multiple field names

Return value:

The maximum value of members of a new sequence obtained by performing computations on members of sequence A.

Example:

 

A

 

1

=demo.query("select * from EMPLOYEE")

 

2

=A1.max(SALARY)

Compute the highest salary

3

=A1.(SALARY+100).max()

Add 100 to the salary of each employee and then compute the highest salary

Related functions:

A.max()