DEV Community

Judy
Judy

Posted on

Getting the first record meeting the specified condition #eg49

Below is part of the Stock table:

Image description
Get the transaction information where the closing price of Merchants Bank (600036) exceeds 25 yuan in the year 2017.
SPL script:

Image description
A2: Find the first record where the closing price exceeds 25 yuan from the beginning.
Execution result:

Image description

SPL open source address

Download

Top comments (0)