DEV Community

From SQL to SPL Series' Articles

Back to Judith-Data-Processing-Hacks's Series
Statistics by Time Window — From SQL to SPL #31
Cover image for Statistics by Time Window — From SQL to SPL #31
judith677 profile

Statistics by Time Window — From SQL to SPL #31

#programming #database #sql #esprocspl
10
Comments 3
3 min read
Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32
judith677 profile

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

#esprocspl #sql #snowflke #tabular
6
Comments 1
2 min read
Total under Recursive Relationship — From SQL to SPL #33
Cover image for Total under Recursive Relationship — From SQL to SPL #33
judith677 profile

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl
7
Comments 1
2 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34
Cover image for Getting the Available Ranges from Two Tables — From SQL to SPL #34
judith677 profile

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

#programming #database #sql #esprocspl
9
Comments 3
3 min read
Get the Initial Date Using the Total — From SQL to SPL #35
Cover image for Get the Initial Date Using the Total — From SQL to SPL #35
judith677 profile

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

#programming #database #sql #esprocspl
6
Comments 3
2 min read
Change Duplicate Contents to NULL — From SQL to SPL #36
Cover image for Change Duplicate Contents to NULL — From SQL to SPL #36
judith677 profile

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

#programming #sql #database #esprocspl
6
Comments 1
2 min read
Conditional Grouping — From SQL to SPL #37
Cover image for Conditional Grouping — From SQL to SPL #37
judith677 profile

Conditional Grouping — From SQL to SPL #37

#programming #database #sql #esprocspl
6
Comments 4
2 min read
Count Distinct within Intervals in Order — From SQL to SPL #38
Cover image for Count Distinct within Intervals in Order — From SQL to SPL #38
judith677 profile

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

#programming #sql #database #esprocspl
6
Comments 2
2 min read
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
Cover image for Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
judith677 profile

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

#programming #database #esprocspl #sql
6
Comments 3
2 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
Cover image for Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
judith677 profile

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

#programming #database #sql #esprocspl
11
Comments 3
2 min read
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
Cover image for Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
judith677 profile

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

#programming #database #sql #esprocspl
10
Comments 3
2 min read
Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42
Cover image for Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42
judith677 profile

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

#programming #database #sql #esprocspl
6
Comments 1
2 min read
Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43
Cover image for Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43
judith677 profile

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

#oracle #programming #sql #esprocspl
6
Comments 1
1 min read