• 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

maxp()

Read（2900） Label: sequence, maximum value,

Here’s how to use maxp() function.

A.m axp()

Description:

Compute expression x over sequence A and return members of A that makes expression x get the greatest value.

Syntax:

A.maxp(x)

Note:

The function computes expression x with each member of sequence A and returns the member which makes the maximum value for expression x.

Option:

 @a Return all the members that fulfill the condition; by default, return the first one @z Search the member from back to front

Parameters:

 A A sequence x An expression that by default returns the last member of sequence A

Return value:

Single value or sequence

Example:

When parameter A is a sequence

 A 1 [6,2,5,6,3,2] 2 =A1.maxp(~*~) 6; return A1’s members that make the expression get the greatest value; by default, only the first eligible member is returned. 3 =A1.maxp@a(~*~) [6,6]; with @a option, return all members that make the expression get the greatest value. 4 =A1.maxp@z(~*0) 2; search backwards. 5 =A1.maxp() 2; as parameter x is absent, return the last member of A1.

When parameter A is a table sequence or a record sequence

 A 1 =demo.query("select top 10 EID,NAME,BIRTHDAY from EMPLOYEE") 2 =A1.maxp@a(BIRTHDAY) Return record of the youngest employee: 3 =A1.maxp() Return the last record of A1:

Related function: