DEV Community

# esprocspl

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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
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
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
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
Segmented Accumulation by Condition — From SQL to SPL #30
judith677 profile

Segmented Accumulation by Condition — From SQL to SPL #30

#programming #database #sql #esprocspl
6
Comments 1
1 min read
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
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
Create Columns from Distinct Values of a Column — From SQL to SPL #26
judith677 profile

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

#programming #esprocspl #database #sql
6
Comments 1
1 min read
Substring from a Column of Strings — From SQL to SPL #25
judith677 profile

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

#programming #database #sql #esprocspl
5
Comments 1
2 min read
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
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24
judith677 profile

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

#programming #database #sql #esprocspl
6
Comments 1
3 min read
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
Count Date Ranges per Year — From SQL to SPL #23
judith677 profile

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

#programming #database #sql #esprocspl
8
Comments 1
2 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
judith677 profile

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

#programming #sql #database #esprocspl
6
Comments 1
2 min read
Aggregate according to Time Interval — From SQL to SPL #27
judith677 profile

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

#programming #database #sql #esprocspl
9
Comments 3
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.