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)

Read next

jenlooper profile image

The Last Saree: Connoisseurship in the Age of AI

Jen Looper -

alexr profile image

💡Only 20% of Developers are Happy at Work?

Alex (The Engineering Bolt) âš¡ -

chiragagg5k profile image

How a Viral Tweet Landed Me Multiple Job Interviews

Chirag Aggarwal -

ben profile image

Experimenting with "following" tab — will give more details once more fully launched. Folks have been asking for something like this for a while.

Ben Halpern -