dev-resources.site

for different kinds of informations.

Multi-condition filtering #eg48

Published at

9/25/2024

Categories

spreadsheet

database

spl

esproc

Author

esproc_spl

Main Article

https://dev.to/esproc_spl/multi-condition-filtering-eg48-1g20

Categories

4 categories in total

Author

10 person written this

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

spl Article's

20 articles in total

Add records that meet the criteria before each group after grouping ：From SQL to SPL

Calculate the hierarchy of recursive references :From SQL to SPL

SQL: Recursive calculation of tree like hierarchical structure #eg83

Is It Necessary to Use a Specialized In-Memory Database?

SQL,Classify time-close events into a group and assign them a number #eg84

What else can Stream&Kotlin evolve into?

Getting members according to primary key values #eg63

Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

The Difference between Each Value in a Certain Column and Its Previous One and Display Result

Group and Summarize data, and align to the specified sequence #eg31

Multi-condition filtering #eg48

currently reading

Getting members based on a specified condition #47

Split a large csv file into smaller files #eg45

Read specified columns from a csv file #eg44

The impasse of SQL performance optimizing

How to Transpose Columns in Each Group to a Single Row

How the performance improvement by orders of magnitude happened

Final association query solution

Hadoop/Spark is too heavy, esProc SPL is light

Datastructures in PHP

Featured ones:

abubakersiddique761