seq()

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

Description:

An interative 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.

Parameters:

Gi

Field name

Options:

@n

The option can increase the numbering efficiency, but can only be used when the specified expression returns a positive integer; support using sequence 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)

Note