Order-related calculation

 

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 sequencelogic 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 sequencesunion sequence and difference sequence

12. Aggregation of sequences of sequencesintersection 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