DEV Community

Judy
Judy

Posted on

2 1 1 1 1

Getting members based on a specified condition #47

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

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs