From SQL to SPL Series&#39; Articles

2 min read

Cover image for Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

Judith-Data-Processing-Hacks

Feb 19

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

#programming #database #opensource #sql

2 min read

Cover image for Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Judith-Data-Processing-Hacks

Feb 21

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

#programming #opensource #sql #dataengineering

2 min read

Cover image for Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

Judith-Data-Processing-Hacks

Feb 25

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

#opensource #sql #dataanalytics #esprocspl

2 min read

Cover image for Flexible Interval Aggregation — From SQL to SPL #5

Judith-Data-Processing-Hacks

Feb 27

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl

2 min read

Cover image for Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

Judith-Data-Processing-Hacks

Mar 3

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

#sql #opensource #mysql #esprocspl

2 min read

Cover image for Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

Judith-Data-Processing-Hacks

Mar 5

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

#sql #dataengineering #opensource #esprocspl

2 min read

Cover image for Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

Judith-Data-Processing-Hacks

Mar 10

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

#sql #esprocspl #datascience #database

3 min read

Cover image for Search for the Closest Matching Record within the Group — From SQL to SPL #9

Judith-Data-Processing-Hacks

Mar 12

Search for the Closest Matching Record within the Group — From SQL to SPL #9

#dataengineering #database #esprocspl #sql

2 min read

Cover image for Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

Judith-Data-Processing-Hacks

Mar 17

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

#dataengineering #database #sql #esprocspl

2 min read

Cover image for Calculate the Hierarchy of Recursive References — From SQL to SPL #11

Judith-Data-Processing-Hacks

Mar 19

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

#dataengineering #sql #esprocspl #database

2 min read

Cover image for Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

Judith-Data-Processing-Hacks

Mar 24

Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

#sql #database #dataengineering #esprocspl

2 min read

Cover image for Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

Judith-Data-Processing-Hacks

Mar 26

Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

#database #dataengineering #sql #esprocspl

2 min read

Cover image for Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

Judith-Data-Processing-Hacks

Mar 31

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

#database #sql #esprocspl #programming

2 min read

Cover image for Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Judith-Data-Processing-Hacks

Apr 2

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl

2 min read

Cover image for Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Judith-Data-Processing-Hacks

Apr 9

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

#programming #dataengineering #sql #esprocspl

2 min read

Cover image for Number Non-Null Values in Order within the Group — From SQL to SPL #17

Judith-Data-Processing-Hacks

Apr 11

Number Non-Null Values in Order within the Group — From SQL to SPL #17

#programming #sql #esprocspl #dataengineering

2 min read

Cover image for Get the Records after and before the Searched One — From SQL to SPL #18

Judith-Data-Processing-Hacks

Apr 14

Get the Records after and before the Searched One — From SQL to SPL #18

#programming #sql #esprocspl #dataengineering

2

2 min read

Cover image for Find the Superset from the Relationship Table — From SQL to SPL #19

Judith-Data-Processing-Hacks

Apr 16

Find the Superset from the Relationship Table — From SQL to SPL #19

#dataengineering #sql #esprocspl #programming

1 min read

Cover image for Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Judith-Data-Processing-Hacks

Apr 18

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

#programming #database #sql #esprocspl

2 min read

Cover image for Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Judith-Data-Processing-Hacks

Apr 22

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

#sql #database #programming #esprocsl

2 min read

Cover image for Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Judith-Data-Processing-Hacks

Apr 24

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

#programming #sql #database #esprocspl

2 min read

Cover image for Count Date Ranges per Year — From SQL to SPL #23

Judith-Data-Processing-Hacks

Apr 27

Count Date Ranges per Year — From SQL to SPL #23

#programming #database #sql #esprocspl

8

2 min read

Cover image for Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Judith-Data-Processing-Hacks

Apr 29

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

#programming #database #sql #esprocspl

3 min read

Cover image for Substring from a Column of Strings — From SQL to SPL #25

Judith-Data-Processing-Hacks

May 6

Substring from a Column of Strings — From SQL to SPL #25

#programming #database #sql #esprocspl

2 min read

Cover image for Create Columns from Distinct Values of a Column — From SQL to SPL #26

Judith-Data-Processing-Hacks

May 8

Create Columns from Distinct Values of a Column — From SQL to SPL #26

#programming #esprocspl #database #sql

1 min read

Cover image for Aggregate according to Time Interval — From SQL to SPL #27

Judith-Data-Processing-Hacks

May 12

Aggregate according to Time Interval — From SQL to SPL #27

#programming #database #sql #esprocspl

9

2 min read

Cover image for Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

Judith-Data-Processing-Hacks

May 14

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

#programming #database #sql #esproc

8

2 min read

Cover image for Generate Calculated Columns Based on Continuous Values — From SQL to SPL #29

Judith-Data-Processing-Hacks

May 16

Generate Calculated Columns Based on Continuous Values — From SQL to SPL #29

#programming #database #sql #esprocspl

2

2 min read

Cover image for Segmented Accumulation by Condition — From SQL to SPL #30

Judith-Data-Processing-Hacks

May 20

Segmented Accumulation by Condition — From SQL to SPL #30

#programming #database #sql #esprocspl

1 min read

Cover image for Statistics by Time Window — From SQL to SPL #31

Judith-Data-Processing-Hacks

May 22

Statistics by Time Window — From SQL to SPL #31

#programming #database #sql #esprocspl

10

3 min read

Judith-Data-Processing-Hacks

May 26

Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32

#esprocspl #sql #snowflke #tabular

2 min read

Cover image for Total under Recursive Relationship — From SQL to SPL #33

Judith-Data-Processing-Hacks

May 28

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl

2 min read

Cover image for Getting the Available Ranges from Two Tables — From SQL to SPL #34

Judith-Data-Processing-Hacks

May 30

Getting the Available Ranges from Two Tables — From SQL to SPL #34

#programming #database #sql #esprocspl

9

3 min read

Cover image for Get the Initial Date Using the Total — From SQL to SPL #35

Judith-Data-Processing-Hacks

Jun 4

Get the Initial Date Using the Total — From SQL to SPL #35

#programming #database #sql #esprocspl

2 min read

Cover image for Change Duplicate Contents to NULL — From SQL to SPL #36

Judith-Data-Processing-Hacks

Jun 6

Change Duplicate Contents to NULL — From SQL to SPL #36

#programming #sql #database #esprocspl

2 min read

Cover image for Conditional Grouping — From SQL to SPL #37

Judith-Data-Processing-Hacks

Jun 10

Conditional Grouping — From SQL to SPL #37

#programming #database #sql #esprocspl

4

2 min read

Cover image for Count Distinct within Intervals in Order — From SQL to SPL #38

Judith-Data-Processing-Hacks

Jun 12

Count Distinct within Intervals in Order — From SQL to SPL #38

#programming #sql #database #esprocspl

2

2 min read

Cover image for Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

Judith-Data-Processing-Hacks

Jun 16

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

#programming #database #esprocspl #sql

2 min read

Cover image for Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Judith-Data-Processing-Hacks

Jun 18

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

#programming #database #sql #esprocspl

11

2 min read

Cover image for Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Judith-Data-Processing-Hacks

Jun 20

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

#programming #database #sql #esprocspl

10

2 min read

Cover image for Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

Judith-Data-Processing-Hacks

Jun 23

Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

#programming #database #sql #esprocspl

2 min read

Cover image for Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

Judith-Data-Processing-Hacks

Jun 26

Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

#oracle #programming #sql #esprocspl