Application •
711 Reference •
71 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
sql(179) text(125) json(28) sql headache(24) group(18) java(14) xml(13) transpose(10) web service(9) mysql(8) topn(6) hive(2) oracle(2) mysql headache(1) compare same period(1) continuous equivalence(1)
sql(179) text(125) json(28) sql headache(24) group(18) java(14) xml(13) transpose(10) web service(9) mysql(8) topn(6) hive(2) oracle(2) mysql headache(1) compare same period(1) continuous equivalence(1)
-
xingjl • Application • 652 View • 2020-03-05 16:53:40
Implement grouping by continuous equivalence from MySQL in one line
-
xingjl • Application • 596 View • 2020-03-05 16:52:23
Take the top three of each group from MySQL in one line
-
xingjl • Application • 782 View • 2023-11-29 21:33:25
Take the top three of each group from Hive in one line
-
xingjl • Application • 549 View • 2020-03-05 16:51:57
Take the top three of each group from Oracle in one line
-
xingjl • Application • 835 View • 2020-03-05 16:51:25
One line code to get same period ratio which is hard to get in SQL
-
xingjl • Application • 858 View • 2020-03-05 16:49:32
* Row and column transposition of dynamic columns in one line
-
-
-
blackduckie • Application • 1,121 View • 2020-01-17 16:58:32
Group & Concatenate MongoDB Subdocuments
-
-
blackduckie • Application • 621 View • 2020-01-17 15:50:17
Get & Concatenate MongoDB Subdocuments by a Condition
-
-
-
blackduckie • Application • 639 View • 2020-01-17 11:28:56
Dynamic Conversion of JSON to Table Sequence
-
-
blackduckie • Application • 635 View • 2020-01-19 17:25:24
Row-to-Column Transposition & Dynamic-column-based Enumerated Grouping
-
blackduckie • Application • 542 View • 2020-01-15 07:13:54
Perform a Huge Number of String Comparisons with esProc
-
-
-
-
-
-
blackduckie • Application • 584 View • 2020-01-12 16:03:37
Multistep Complex SQL Queries Optimization Example
-
-
blackduckie • Application • 581 View • 2020-01-08 14:58:54
Order-based Calculations: Conditional Query involving Multi-fields