dev-resources.site

for different kinds of informations.

Getting positions of members based on a specified condition #eg46

Published at

9/23/2024

Categories

database

spreadsheet

esproc

learning

Author

esproc_spl

Main Article

https://dev.to/esproc_spl/getting-positions-of-members-based-on-a-specified-condition-eg46-2j8f

Categories

4 categories in total

Author

10 person written this

Getting positions of members based on a specified condition #eg46

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

SPL script:

A1 Connect to the database;
A2 Retrieve Scores table from the database;
A3 Get ordinal numbers of records where SCORE is 90 or above. pselect@a returns ordinal numbers of all records meeting the specified condition. Without @a option, pselect function returns ordinal number of the first found eligible record only.

SPL open source address

esproc Article's

30 articles in total

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

Multi combination condition grouping and aggregation #eg93

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Group & Summarize a CSV File #eg68

Getting positions of members according to primary key values #eg58

Getting members according to primary key values #eg63

How to Access Databases using One SQL Statement #eg71

Filter a CSV file and re-arrange it by category #eg60

Getting positions of members based on a specified condition #eg46

currently reading

Convert Each Whites-space-separated Text Block into a Row #eg62

Perform Distinct on Ordered Numbers in a Text File #eg61

Parse a csv file having a primary-sub tables structure #eg41

Convert CSV Data into Multilevel JSON #eg56

Add a compute column to a csv file #eg40

SQL, in each group modify the null value of a specified column as its neighboring value #eg43

Get the whole group where at least one member meets the specified condition #eg36

Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

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

Reverse Rows in a Text File #eg51

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

Java, perform COUNT on each group of a large csv file #eg33

SQL, extract unique values of JSON format field from each group #eg42

Multi-condition filtering #eg48

Getting members based on a specified condition #47

Read specified columns from a csv file #eg44

Something could double the development efficiency of Java programmers

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

To Index Data is To Sort Data

Clear duplicate lines and lines having missing values from a csv file #eg24

SQL, Set different flags for different groups according to whether there are duplicate values #eg19

Featured ones:

abubakersiddique761