seq()

Read(2291) Label: loop operation, number records,

Description:

An iterative loop for numbering records in which a certain field contains same values.

Syntax:

seq(Gi,…)

Note:

The function performs a loop operation to number records with the same Gi field value from 1. As the value of field changes, number the records from 1 again.

Parameter:

Gi

Field name

Option:

@n

The option can increase the numbering efficiency, but can only be used when the specified expression returns a positive integer; support using ordinal numbers

Return value:

Cursor

Example:

 

A

 

1

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

 

2

=A1.derive(seq(CLASS):F1)

3

=A1.derive(seq(CLASS,STUDENTID):F1)