Getting members based on a specified condition #47
Judy

Judy @esproc_spl

About: Like open source, follow open source

Joined:
Oct 23, 2023

Getting members based on a specified condition #47

Publish Date: Sep 24 '24
6 0

Find student records in the Scores table where SCORE is 90 or above.

Image description
SPL script:

Image description
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

Comments 0 total

    Add comment