Minimun value: min

Syntax

Aggregate syntax

in a Data Set expression	min ( dataset { groupingClause } )
in a Component expression within an aggr clause	min ( component ) { groupingClause }

Analytic syntax

in a Data Set expression	min ( dataset over ( analyticClause ) )
in a Component expression within a calc clause	min ( component over ( analyticClause ) )

Input parameters

dataset	the operand Data Set
component	the operand Component
groupingClause	see Aggregate invocation
analyticClause	see Analytic invocation

Semantics for scalar operations

This operator cannot be applied to scalar values.

Input parameters type

dataset

dataset

component

component

Result type

result

dataset
| component

For numeric operands, the result has the same type as the operand (integer or number). For other comparable scalar types (for example time, string, boolean), the result has the same type as the operand.

Additional Constraints

None.

Behaviour

The operator returns the minimum value of the input values. For other details, see Aggregate and Analytic invocations.

Examples

Given the operand dataset DS_1:

Input DS_1 (see structure)

Id_1	Id_2	Id_3	Me_1
2011	A	XX	3
2011	A	YY	5
2011	B	YY	7
2012	A	XX	2
2012	B	YY	4

Example 1

DS_r := min ( DS_1 group by Id_1 );

results in (see structure):

DS_r
Id_1	Me_1
2011	3
2012	2