Application •
712 Reference •
71 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
sql(179) text(125) json(28) sql headache(24) java(14) xml(13) transpose(10) web service(9) topn(6) hive(2) oracle(2) mysql headache(1) compare same period(1)
sql(179) text(125) json(28) sql headache(24) java(14) xml(13) transpose(10) web service(9) topn(6) hive(2) oracle(2) mysql headache(1) compare same period(1)
-
xingjl • Application • 622 View • 2020-03-05 16:52:23
Take the top three of each group from MySQL in one line
-
xingjl • Application • 823 View • 2023-11-29 21:33:25
Take the top three of each group from Hive in one line
-
xingjl • Application • 581 View • 2020-03-05 16:51:57
Take the top three of each group from Oracle in one line
-
xingjl • Application • 867 View • 2020-03-05 16:51:25
One line code to get same period ratio which is hard to get in SQL
-
xingjl • Application • 884 View • 2020-03-05 16:49:32
* Row and column transposition of dynamic columns in one line
-
-
-
blackduckie • Application • 1,169 View • 2020-01-17 16:58:32
Group & Concatenate MongoDB Subdocuments
-
-
blackduckie • Application • 635 View • 2020-01-17 15:50:17
Get & Concatenate MongoDB Subdocuments by a Condition
-
-
-
blackduckie • Application • 668 View • 2020-01-17 11:28:56
Dynamic Conversion of JSON to Table Sequence
-
-
blackduckie • Application • 656 View • 2020-01-19 17:25:24
Row-to-Column Transposition & Dynamic-column-based Enumerated Grouping
-
blackduckie • Application • 564 View • 2020-01-15 07:13:54
Perform a Huge Number of String Comparisons with esProc
-
-
-
-
-
-
blackduckie • Application • 618 View • 2020-01-12 16:03:37
Multistep Complex SQL Queries Optimization Example
-
-
blackduckie • Application • 612 View • 2020-01-08 14:58:54
Order-based Calculations: Conditional Query involving Multi-fields
-
blackduckie • Application • 783 View • 2020-01-08 11:46:14
Pass a Multi-value Parameter to BIRT’s SQL Data Set