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 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
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL