DEV Community

Judy
Judy

Posted on

Multi-condition filtering #eg48

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

Top comments (0)