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

SPL script:

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