-
From SQL to SPL: Add records that meet the criteria before each group after grouping
Application • 0 Reply • 69 View • 2024-12-21 17:42 -
From SQL to SPL: Pair and transpose adjacent records within the group
Application • 0 Reply • 1 View • 2024-12-21 17:39 -
From SQL to SPL: Calculate the number of intersections between adjacent subsets after grouping
Application • 0 Reply • 14 View • 2024-12-20 16:35 -
From SQL to SPL: Calculate all the year/months included in the year/month interval
Application • 0 Reply • 23 View • 2024-12-19 16:40 -
From SQL to SPL: Getting values from multiple format strings to multiple records
Application • 0 Reply • 22 View • 2024-12-18 17:50 -
From SQL to SPL: Number non null values in order within the group
Application • 0 Reply • 32 View • 2024-12-13 18:43 -
From SQL to SPL: Count distinct within intervals in order
Application • 0 Reply • 27 View • 2024-12-13 18:41 -
Determine whether to filter again based on the situation in the filtered result set
Application • 0 Reply • 53 View • 2024-12-05 17:50 -
Multi combination condition grouping and aggregation
Application • 0 Reply • 51 View • 2024-12-05 17:49 -
Search for records containing a specified string group in multi fields
Application • 0 Reply • 47 View • 2024-12-04 08:38 -
Row to column conversion involving uncertain columns
Application • 0 Reply • 52 View • 2024-12-04 08:34 -
SQL: Split a string with an uncertain number of segments into multiple columns
Application • 0 Reply • 80 View • 2024-11-28 17:17 -
SQL: Generate event sequence numbers within a specified time interval
Application • 0 Reply • 76 View • 2024-11-28 17:15 -
SQL: Query the records closest to the specified time each day
Application • 0 Reply • 83 View • 2024-11-26 15:44 -
SQL: Perform statistics at different granularities based on the time span of the data
Application • 0 Reply • 70 View • 2024-11-26 11:28 -
SQL,Classify time-close events into a group and assign them a number
Application • 0 Reply • 92 View • 2024-11-22 16:58 -
SQL: Recursive calculation of tree like hierarchical structure
Application • 0 Reply • 84 View • 2024-11-21 18:25 -
SQL: Identify associated member groups without common points of association
Application • 0 Reply • 80 View • 2024-11-19 17:16 -
SQL: Multi field mixed deduplication followed by numbering
Application • 0 Reply • 69 View • 2024-11-15 17:32 -
Group and Summarize rows and add different words after different counts
Desktop • 0 Reply • 154 View • 2024-09-19 18:57 -
-
-
Search for a specified string across the whole table
Desktop • 0 Reply • 234 View • 2024-09-05 11:06 -
SQL, in each group modify the null value of a specified column as its neighboring value
Application • 0 Reply • 335 View • 2024-09-05 11:04 -
-
SQL, extract unique values of JSON format field from each group
Application • 0 Reply • 348 View • 2024-09-04 15:43 -
Parse a csv file having a primary-sub tables structure
Application • 0 Reply • 221 View • 2024-09-03 16:26 -
Find how many times two specified members will be contained in a series of sets
Desktop • 0 Reply • 332 View • 2024-09-03 16:24 -
-