Multi-condition filtering #eg48
Judy

Judy @esproc_spl

About: Like open source, follow open source

Joined:
Oct 23, 2023

Multi-condition filtering #eg48

Publish Date: Sep 25 '24
6 0

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

Comments 0 total

    Add comment