DEV Community

From SQL to SPL Series' Articles

Back to Judith-Data-Processing-Hacks's Series
Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1
Cover image for Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1
judith677 profile

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

#programming #sql #database #opensource
6
Comments
2 min read
Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2
Cover image for Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2
judith677 profile

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

#programming #database #opensource #sql
6
Comments 1
2 min read
Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3
Cover image for Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3
judith677 profile

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

#programming #opensource #sql #dataengineering
9
Comments 1
2 min read
Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4
Cover image for Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4
judith677 profile

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

#opensource #sql #dataanalytics #esprocspl
7
Comments 1
2 min read
Flexible Interval Aggregation — From SQL to SPL #5
Cover image for Flexible Interval Aggregation — From SQL to SPL #5
judith677 profile

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl
7
Comments 1
2 min read
Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6
Cover image for Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6
judith677 profile

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
Comments 1
2 min read
Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7
Cover image for Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7
judith677 profile

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

#sql #dataengineering #opensource #esprocspl
7
Comments 1
2 min read
Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8
Cover image for Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8
judith677 profile

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
Comments 1
3 min read
Search for the Closest Matching Record within the Group — From SQL to SPL #9
Cover image for Search for the Closest Matching Record within the Group — From SQL to SPL #9
judith677 profile

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

#dataengineering #database #esprocspl #sql
6
Comments 1
2 min read