DEV Community

Judy
Judy

Posted on

Getting positions of members based on a specified condition #eg46

Find ordinal numbers of the student records in the Scores table where SCORE is 90 or above.

Image description
SPL script:

Image description

A1 Connect to the database;
A2 Retrieve Scores table from the database;
A3 Get ordinal numbers of records where SCORE is 90 or above. pselect@a returns ordinal numbers of all records meeting the specified condition. Without @a option, pselect function returns ordinal number of the first found eligible record only.

SPL open source address

Free download

Top comments (0)