Application •
652 Reference •
64 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) conditional change(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) conditional change(1) continuous equivalence(1)
-
xingjl • Application • 559 View • 2020-03-05 08:53:33
. Implement grouping by conditional change from MySQL in one line
-
xingjl • Application • 575 View • 2020-03-05 08:53:40
Implement grouping by continuous equivalence from MySQL in one line
-
xingjl • Application • 541 View • 2020-03-05 08:52:23
Take the top three of each group from MySQL in one line
-
xingjl • Application • 660 View • 2023-11-29 13:33:25
Take the top three of each group from Hive in one line
-
xingjl • Application • 489 View • 2020-03-05 08:51:57
Take the top three of each group from Oracle in one line
-
xingjl • Application • 734 View • 2020-03-05 08:51:25
One line code to get same period ratio which is hard to get in SQL
-
xingjl • Application • 775 View • 2020-03-05 08:49:32
* Row and column transposition of dynamic columns in one line
-
-
-
blackduckie • Application • 1,049 View • 2020-01-17 08:58:32
Group & Concatenate MongoDB Subdocuments
-
-
blackduckie • Application • 541 View • 2020-01-17 07:50:17
Get & Concatenate MongoDB Subdocuments by a Condition
-
-
-
blackduckie • Application • 580 View • 2020-01-17 03:28:56
Dynamic Conversion of JSON to Table Sequence
-
-
blackduckie • Application • 573 View • 2020-01-19 09:25:24
Row-to-Column Transposition & Dynamic-column-based Enumerated Grouping
-
blackduckie • Application • 494 View • 2020-01-14 23:13:54
Perform a Huge Number of String Comparisons with esProc
-
-
-
-
-
-
blackduckie • Application • 512 View • 2020-01-12 08:03:37
Multistep Complex SQL Queries Optimization Example
-