TopN and variants
I. Max / Min
1. Get the value
2. Get the row number of the corresponding record
3. Get the corresponding record
II. TopN
1. Get the value
2. Get the row number of the corresponding record
3. Get the corresponding record
III. Use in grouping
1. TopN calculations on subsets
2. TopN calculations in cumulative mode
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProcSPL
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