Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
#
esproc
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Multi-condition filtering #eg48
Judy
Judy
Judy
Follow
Sep 25
Multi-condition filtering #eg48
#
spreadsheet
#
database
#
spl
#
esproc
6
reactions
Comments
Add Comment
1 min read
Getting positions of members based on a specified condition #eg46
Judy
Judy
Judy
Follow
Sep 23
Getting positions of members based on a specified condition #eg46
#
database
#
spreadsheet
#
esproc
#
learning
11
reactions
Comments
Add Comment
1 min read
Getting members based on a specified condition #47
Judy
Judy
Judy
Follow
Sep 24
Getting members based on a specified condition #47
#
programming
#
spl
#
esproc
#
spreadsheet
7
reactions
Comments
Add Comment
1 min read
Parse a csv file having a primary-sub tables structure #eg41
Judy
Judy
Judy
Follow
Sep 13
Parse a csv file having a primary-sub tables structure #eg41
#
learning
#
programming
#
beginners
#
esproc
6
reactions
Comments
Add Comment
2 min read
Add a compute column to a csv file #eg40
Judy
Judy
Judy
Follow
Sep 12
Add a compute column to a csv file #eg40
#
java
#
programming
#
devops
#
esproc
10
reactions
Comments
Add Comment
1 min read
SQL, in each group modify the null value of a specified column as its neighboring value #eg43
Judy
Judy
Judy
Follow
Sep 18
SQL, in each group modify the null value of a specified column as its neighboring value #eg43
#
sql
#
programming
#
esproc
#
java
7
reactions
Comments
Add Comment
1 min read
Get the whole group where at least one member meets the specified condition #eg36
Judy
Judy
Judy
Follow
Sep 4
Get the whole group where at least one member meets the specified condition #eg36
#
sql
#
development
#
programming
#
esproc
6
reactions
Comments
Add Comment
2 min read
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35
Judy
Judy
Judy
Follow
Sep 2
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35
#
sql
#
development
#
programming
#
esproc
6
reactions
Comments
Add Comment
1 min read
Java, perform COUNT on each group of a large csv file #eg33
Judy
Judy
Judy
Follow
Aug 28
Java, perform COUNT on each group of a large csv file #eg33
#
sql
#
development
#
database
#
esproc
6
reactions
Comments
Add Comment
2 min read
SQL, extract unique values of JSON format field from each group #eg42
Judy
Judy
Judy
Follow
Sep 14
SQL, extract unique values of JSON format field from each group #eg42
#
sql
#
json
#
programming
#
esproc
10
reactions
Comments
Add Comment
2 min read
Read specified columns from a csv file #eg44
Judy
Judy
Judy
Follow
Sep 19
Read specified columns from a csv file #eg44
#
csv
#
java
#
esproc
#
spl
6
reactions
Comments
Add Comment
1 min read
Something could double the development efficiency of Java programmers
Judy
Judy
Judy
Follow
Sep 6
Something could double the development efficiency of Java programmers
#
java
#
programming
#
devops
#
esproc
7
reactions
Comments
Add Comment
6 min read
Java, fill each row having a null value in a csv file with values in the directly previous row #eg32
Judy
Judy
Judy
Follow
Aug 27
Java, fill each row having a null value in a csv file with values in the directly previous row #eg32
#
sql
#
development
#
programming
#
esproc
6
reactions
Comments
Add Comment
1 min read
To Index Data is To Sort Data
Judy
Judy
Judy
Follow
Aug 26
To Index Data is To Sort Data
#
sql
#
database
#
bigdata
#
esproc
8
reactions
Comments
Add Comment
5 min read
Clear duplicate lines and lines having missing values from a csv file #eg24
Judy
Judy
Judy
Follow
Aug 14
Clear duplicate lines and lines having missing values from a csv file #eg24
#
sql
#
programming
#
development
#
esproc
7
reactions
Comments
1
comment
1 min read
Compare two csv files #eg34
Judy
Judy
Judy
Follow
Aug 29
Compare two csv files #eg34
#
sql
#
development
#
programming
#
esproc
7
reactions
Comments
1
comment
1 min read
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
Judy
Judy
Judy
Follow
Aug 7
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
#
sql
#
development
#
programming
#
esproc
8
reactions
Comments
1
comment
1 min read
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18
Judy
Judy
Judy
Follow
Aug 6
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18
#
sql
#
development
#
programming
#
esproc
6
reactions
Comments
1
comment
1 min read
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16
Judy
Judy
Judy
Follow
Aug 2
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16
#
sql
#
development
#
programming
#
esproc
6
reactions
Comments
1
comment
2 min read
SQL, mark continuous rows with sequence numbers #eg30
Judy
Judy
Judy
Follow
Aug 22
SQL, mark continuous rows with sequence numbers #eg30
#
sql
#
development
#
programming
#
esproc
8
reactions
Comments
Add Comment
1 min read
SQL, get historical status of each ID #eg22
Judy
Judy
Judy
Follow
Aug 12
SQL, get historical status of each ID #eg22
#
sql
#
development
#
programming
#
esproc
8
reactions
Comments
1
comment
1 min read
SQL, output associated records having many-to-many relationship row by row #eg26
Judy
Judy
Judy
Follow
Aug 16
SQL, output associated records having many-to-many relationship row by row #eg26
#
sql
#
development
#
programming
#
esproc
8
reactions
Comments
Add Comment
1 min read
Retrieve multiple columns from a csv file to generate a new file #eg23
Judy
Judy
Judy
Follow
Aug 13
Retrieve multiple columns from a csv file to generate a new file #eg23
#
softwaredevelopment
#
development
#
programming
#
esproc
7
reactions
Comments
1
comment
1 min read
SQL, compute cumulative sums according to the termination condition #eg29
Judy
Judy
Judy
Follow
Aug 21
SQL, compute cumulative sums according to the termination condition #eg29
#
sql
#
development
#
programming
#
esproc
7
reactions
Comments
1
comment
1 min read
SQL, parse json data #eg28
Judy
Judy
Judy
Follow
Aug 20
SQL, parse json data #eg28
#
sql
#
development
#
programming
#
esproc
11
reactions
Comments
Add Comment
1 min read