-
Determine whether to filter again based on the situation in the filtered result set
Application • 0 Reply • 120 View • 2024-12-05 17:50 -
Multi combination condition grouping and aggregation
Application • 0 Reply • 115 View • 2024-12-05 17:49 -
SQL: Split a string with an uncertain number of segments into multiple columns
Application • 0 Reply • 159 View • 2024-11-28 17:17 -
SQL: Query the records closest to the specified time each day
Application • 0 Reply • 155 View • 2024-11-26 15:44 -
SQL: Perform statistics at different granularities based on the time span of the data
Application • 0 Reply • 129 View • 2024-11-26 11:28 -
SQL,Classify time-close events into a group and assign them a number
Application • 0 Reply • 179 View • 2024-11-22 16:58 -
SQL: Recursive calculation of tree like hierarchical structure
Application • 0 Reply • 165 View • 2024-11-21 18:25 -
SQL: Identify associated member groups without common points of association
Application • 0 Reply • 140 View • 2024-11-19 17:16 -
SQL: Multi field mixed deduplication followed by numbering
Application • 0 Reply • 132 View • 2024-11-15 17:32 -
Group and Summarize rows and add different words after different counts
Desktop • 0 Reply • 220 View • 2024-09-19 18:57 -
-
-
Search for a specified string across the whole table
Desktop • 0 Reply • 286 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 • 380 View • 2024-09-05 11:04 -
-
SQL, extract unique values of JSON format field from each group
Application • 0 Reply • 436 View • 2024-09-04 15:43 -
Parse a csv file having a primary-sub tables structure
Application • 0 Reply • 299 View • 2024-09-03 16:26 -
Find how many times two specified members will be contained in a series of sets
Desktop • 0 Reply • 374 View • 2024-09-03 16:24 -
-
-
Process a large csv file with parallel processing
Application • 0 Reply • 240 View • 2024-09-02 16:10 -
Split each row into multiple rows according to the specified rule
Desktop • 0 Reply • 216 View • 2024-09-02 16:09 -
Concatenate column titles corresponding to empty cells
Desktop • 0 Reply • 178 View • 2024-08-30 15:09 -
-
Split values of a field in a database table and transform it to new fields
Application • 0 Reply • 166 View • 2024-08-30 11:25 -
-
-
Get the whole group where at least one member meets the specified condition
Application • 0 Reply • 191 View • 2024-08-28 14:34 -
Combine cell values of every 3 rows under each column into one cell
Desktop • 0 Reply • 224 View • 2024-08-27 16:25 -
Parse a csv file where field values are enclosed by quotation marks and contain carriage return
Application • 0 Reply • 220 View • 2024-08-27 14:58