shlogg · Early preview
Judy @esproc_spl

Ordinal Numbers In Scores Table: SCORE 90+ Records

Find ordinal numbers of student records with SCORE 90+ in Scores table using SPL script: A1 Connect to db; A2 Retrieve Scores table; A3 Get ordinal numbers where SCORE is 90 or above.

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