-
jinxing • Application • 33 View • 2025-02-26 22:34:43
From SQL to SPL: Deduplicate between an uncertain number of columns
-
jinxing • Application • 38 View • 2025-02-25 17:39:05
From SQL to SPL: Find the closest date match for each record from two tables
-
jinxing • Application • 29 View • 2025-02-20 17:28:34
From SQL to SPL: Find the superset from the relationship table
-
jinxing • Application • 32 View • 2025-02-19 17:46:57
From SQL to SPL: Get the records after and before the searched one
-
jinxing • Application • 40 View • 2025-02-17 09:07:48
From SQL to SPL: Do ordered grouping and aggregation within groups
-
jinxing • Application • 142 View • 2025-02-17 09:18:17
From SQL to SPL: Track Production Operations Outcome Progression with Conditional NULLs
-
-
jinxing • Application • 123 View • 2025-02-17 09:40:47
From SQL to SPL: Convert cross cell to row header, row header to column
-
jinxing • Application • 121 View • 2025-02-17 09:45:33
From SQL to SPL: Flexible interval aggregation
-
-
-
jinxing • Application • 156 View • 2025-02-17 10:08:20
From SQL to SPL: Uncertain number but regular column to row conversion
-
-
jinxing • Application • 119 View • 2025-02-17 10:34:39
From SQL to SPL: Search for the closest matching record within the group
-
jinxing • Application • 125 View • 2025-02-17 10:38:12
From SQL to SPL: Calculate monthly account balance and fill in missing dates
-
jinxing • Application • 134 View • 2025-02-17 10:42:57
From SQL to SPL: Calculate the hierarchy of recursive references
-
-
-
-
jinxing • Application • 145 View • 2024-12-21 17:39:40
From SQL to SPL: Pair and transpose adjacent records within the group
-
-
jinxing • Application • 176 View • 2024-12-19 16:40:11
From SQL to SPL: Calculate all the year/months included in the year/month interval
-
jinxing • Application • 122 View • 2024-12-18 17:50:17
From SQL to SPL: Getting values from multiple format strings to multiple records
-
jinxing • Application • 120 View • 2024-12-13 18:43:26
From SQL to SPL: Number non null values in order within the group
-
jinxing • Application • 147 View • 2024-12-13 18:41:15
From SQL to SPL: Count distinct within intervals in order