## I. Sequence number access

### 1. Single sequence number access

### 2. Multiple sequence number access

## II. Basic operations

### 1. Operation between two sequences: sequence comparison

### 2. Operation between two sequences: sum and difference

### 3. Operation between two sequences: union and intersection

### 4. Operation between two sequences: the four fundamental operations

### 5. Operation between two sequences: member comparison

### 6. Operation between sequence and single value

## III. Aggregation

### 1. Aggregation of a single sequence: sum

### 2. Aggregation of a single sequence: maximum, minimum

### 3. Aggregation of a single sequence:average

### 4. Aggregation of a single sequence:count

### 5. Aggregation of a single sequence：logic and operation

### 6. Aggregation of a single sequence: logic or operation

### 7. Aggregation of a single sequence: non repeating count

### 8. Aggregation of a single sequence: median

### 9. Aggregation of a single sequence: ranking

### 10. Aggregation of sequences of sequences: sum sequence

### 11. Aggregation of sequences of sequences：union sequence and difference sequence

### 12. Aggregation of sequences of sequences：intersection sequence

### 13. Aggregation of sequences of sequences: XOR sequence

## IV. Loop calculation

### 1. Loop function

### 2. Symbol

### 3. Positioning calculation

### 4. Iteration calculation

## V. Positioning

### 1. Locate a member's position in the sequence

### 2. Take the row number of the record corresponding to the maximum / minimum value

### 3. Get the member sequence number that meets the condition

### 4. Segment sequence number of member in sequence

### 5. Get the original sequence number of a sorted member

### 6. Overall positioning of sequence

### 7. Determine whether it is a sequence member

### 8. Find row number of primary key

### 9. Get the row numbers corresponding to TopN records

## VI. Select

### 1. Get the record corresponding to the minimum value

### 2. Get the record corresponding to the maximum value

### 3. Select member that meets the condition

### 4. Return the corresponding member in the sequence according to the section number

### 5. Sort

### 6. GetTopNrecords

### 7. Find the record where the primary key is located

Click to download the PDF file