Multi-condition filtering #eg48

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

SPL script:

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, s…


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


Print Share Comment Cite Upload Translate Updates
APA

Judy | Sciencx (2024-09-25T06:00:51+00:00) Multi-condition filtering #eg48. Retrieved from https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/

MLA
" » Multi-condition filtering #eg48." Judy | Sciencx - Wednesday September 25, 2024, https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/
HARVARD
Judy | Sciencx Wednesday September 25, 2024 » Multi-condition filtering #eg48., viewed ,<https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/>
VANCOUVER
Judy | Sciencx - » Multi-condition filtering #eg48. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/
CHICAGO
" » Multi-condition filtering #eg48." Judy | Sciencx - Accessed . https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/
IEEE
" » Multi-condition filtering #eg48." Judy | Sciencx [Online]. Available: https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/. [Accessed: ]
rf:citation
» Multi-condition filtering #eg48 | Judy | Sciencx | https://www.scien.cx/2024/09/25/multi-condition-filtering-eg48/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.