From SQL to SPL Series' Articles

Cover image for Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

Judith-Data-Processing-Hacks

Feb 18 '25

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

#programming #sql #database #opensource

6

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 '25

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

#programming #database #opensource #sql

5

1

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 '25

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

#programming #opensource #sql #dataengineering

7

1

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 '25

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

#opensource #sql #dataanalytics #esprocspl

7

1

2 min read

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

Judith-Data-Processing-Hacks

Feb 27 '25

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl

7

1

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 '25

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

7

1

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 '25

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

#sql #dataengineering #opensource #esprocspl

7

1

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 '25

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

7

1

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 '25

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

#dataengineering #database #esprocspl #sql

6

1

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 '25

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

#dataengineering #database #sql #esprocspl

6

1

2 min read

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

Judith-Data-Processing-Hacks

Mar 19 '25

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

#dataengineering #sql #esprocspl #database

5

1

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 '25

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

#sql #database #dataengineering #esprocspl

6

1

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 '25

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

#database #dataengineering #sql #esprocspl

6

1

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 '25

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

#database #sql #esprocspl #programming

5

1

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 '25

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

#programming #datascience #sql #esprocspl

5

1

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 '25

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

#programming #dataengineering #sql #esprocspl

6

1

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 '25

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

#programming #sql #esprocspl #dataengineering

6

1

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 '25

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

#programming #sql #esprocspl #dataengineering

7

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 '25

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

#dataengineering #sql #esprocspl #programming

1

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 '25

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

#programming #database #sql #esprocspl

6

1

2 min read

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

Judith-Data-Processing-Hacks

Apr 22 '25

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

#sql #database #programming #esprocsl

7

1

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 '25

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

#programming #sql #database #esprocspl

6

1

2 min read

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

Judith-Data-Processing-Hacks

Apr 27 '25

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

#programming #database #sql #esprocspl

8

1

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 '25

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

#programming #database #sql #esprocspl

6

1

3 min read

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

Judith-Data-Processing-Hacks

May 6 '25

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

#programming #database #sql #esprocspl

5

1

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 '25

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

#programming #esprocspl #database #sql

6

1

1 min read

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

Judith-Data-Processing-Hacks

May 12 '25

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

#programming #database #sql #esprocspl

9

3

2 min read

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

Judith-Data-Processing-Hacks

May 14 '25

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

#programming #database #sql #esproc

8

1

2 min read

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

Judith-Data-Processing-Hacks

May 16 '25

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

#programming #database #sql #esprocspl

1

2

2 min read

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

Judith-Data-Processing-Hacks

May 20 '25

Segmented Accumulation by Condition — From SQL to SPL #30

#programming #database #sql #esprocspl

6

1

1 min read

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

Judith-Data-Processing-Hacks

May 22 '25

Statistics by Time Window — From SQL to SPL #31

#programming #database #sql #esprocspl

10

3

3 min read

Judith-Data-Processing-Hacks

May 26 '25

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

#esprocspl #sql #snowflke #tabular

6

1

2 min read

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

Judith-Data-Processing-Hacks

May 28 '25

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl

7

1

2 min read

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

Judith-Data-Processing-Hacks

May 30 '25

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

#programming #database #sql #esprocspl

9

3

3 min read

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

Judith-Data-Processing-Hacks

Jun 4 '25

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

#programming #database #sql #esprocspl

6

3

2 min read

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

Judith-Data-Processing-Hacks

Jun 6 '25

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

#programming #sql #database #esprocspl

6

1

2 min read

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

Judith-Data-Processing-Hacks

Jun 10 '25

Conditional Grouping — From SQL to SPL #37

#programming #database #sql #esprocspl

6

4

2 min read

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

Judith-Data-Processing-Hacks

Jun 12 '25

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

#programming #sql #database #esprocspl

6

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 '25

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

#programming #database #esprocspl #sql

6

3

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 '25

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

#programming #database #sql #esprocspl

11

3

2 min read

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

Judith-Data-Processing-Hacks

Jun 20 '25

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

#programming #database #sql #esprocspl

10

3

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 '25

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

#programming #database #sql #esprocspl

6

1

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 '25

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

#oracle #programming #sql #esprocspl

6

1

1 min read