Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Log in
Create account
Forem
Close
#
esprocspl
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 26
Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43
#
oracle
#
programming
#
sql
#
esprocspl
6
reactions
Comments
1
comment
1 min read
Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 23
Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
1
comment
2 min read
Count Distinct within Intervals in Order — From SQL to SPL #38
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 12
Count Distinct within Intervals in Order — From SQL to SPL #38
#
programming
#
sql
#
database
#
esprocspl
6
reactions
Comments
2
comments
2 min read
Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 26
Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32
#
esprocspl
#
sql
#
snowflke
#
tabular
6
reactions
Comments
1
comment
2 min read
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 16
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
#
programming
#
database
#
esprocspl
#
sql
6
reactions
Comments
3
comments
2 min read
Segmented Accumulation by Condition — From SQL to SPL #30
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 20
Segmented Accumulation by Condition — From SQL to SPL #30
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
1
comment
1 min read
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 20
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
#
programming
#
database
#
sql
#
esprocspl
10
reactions
Comments
3
comments
2 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 18
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
#
programming
#
database
#
sql
#
esprocspl
12
reactions
Comments
3
comments
2 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 8
Create Columns from Distinct Values of a Column — From SQL to SPL #26
#
programming
#
esprocspl
#
database
#
sql
6
reactions
Comments
1
comment
1 min read
Substring from a Column of Strings — From SQL to SPL #25
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 6
Substring from a Column of Strings — From SQL to SPL #25
#
programming
#
database
#
sql
#
esprocspl
5
reactions
Comments
1
comment
2 min read
Total under Recursive Relationship — From SQL to SPL #33
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 28
Total under Recursive Relationship — From SQL to SPL #33
#
programming
#
database
#
sql
#
esprocspl
7
reactions
Comments
1
comment
2 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 29
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
1
comment
3 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 30
Getting the Available Ranges from Two Tables — From SQL to SPL #34
#
programming
#
database
#
sql
#
esprocspl
9
reactions
Comments
3
comments
3 min read
Count Date Ranges per Year — From SQL to SPL #23
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 27
Count Date Ranges per Year — From SQL to SPL #23
#
programming
#
database
#
sql
#
esprocspl
8
reactions
Comments
1
comment
2 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 24
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
#
programming
#
sql
#
database
#
esprocspl
6
reactions
Comments
1
comment
2 min read
Aggregate according to Time Interval — From SQL to SPL #27
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 12
Aggregate according to Time Interval — From SQL to SPL #27
#
programming
#
database
#
sql
#
esprocspl
9
reactions
Comments
3
comments
2 min read
Statistics by Time Window — From SQL to SPL #31
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 22
Statistics by Time Window — From SQL to SPL #31
#
programming
#
database
#
sql
#
esprocspl
10
reactions
Comments
3
comments
3 min read
Find the Superset from the Relationship Table — From SQL to SPL #19
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 16
Find the Superset from the Relationship Table — From SQL to SPL #19
#
dataengineering
#
sql
#
esprocspl
#
programming
1
reaction
Comments
1
comment
1 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 11
Number Non-Null Values in Order within the Group — From SQL to SPL #17
#
programming
#
sql
#
esprocspl
#
dataengineering
6
reactions
Comments
1
comment
2 min read
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 9
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
#
programming
#
dataengineering
#
sql
#
esprocspl
6
reactions
Comments
1
comment
2 min read
Get the Initial Date Using the Total — From SQL to SPL #35
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 4
Get the Initial Date Using the Total — From SQL to SPL #35
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
3
comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 2
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
#
programming
#
datascience
#
sql
#
esprocspl
5
reactions
Comments
1
comment
2 min read
Conditional Grouping — From SQL to SPL #37
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 10
Conditional Grouping — From SQL to SPL #37
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
4
comments
2 min read
Get the Records after and before the Searched One — From SQL to SPL #18
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 14
Get the Records after and before the Searched One — From SQL to SPL #18
#
programming
#
sql
#
esprocspl
#
dataengineering
7
reactions
Comments
2
comments
2 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 18
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
#
programming
#
database
#
sql
#
esprocspl
6
reactions
Comments
1
comment
2 min read
loading...
We're a blogging-forward open source social network where we learn from one another
Log in
Create account