shlogg · Early preview
Judy @esproc_spl

Retrieving Student Records With Scores 90+ Using SPL Script

Find student scores >= 90: A1 Connect to db; A2 Retrieve Scores table; A3 Get records where SCORE is 90 or above using select() with @1 option.

Find 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 records where SCORE is 90 or above. By default, select()returns all records meeting the specified condition. To return the first found eligible record only, use @1 option in select() function.
Open source address
Download