Multi-condition filtering #eg48



This content originally appeared on DEV Community and was authored by Judy

Find records of students in class one whose math score is 90 or above from Scores table.

Image description
SPL script:

Image description

A1 Connect to the database;
A2 Retrieve Scores table from the database;
A3 Get records of class one where math 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.

SPL open source address

Download


This content originally appeared on DEV Community and was authored by Judy