-
xingjl • Application • 780 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 • 811 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 • 638 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 • 541 View • 2020-01-15 07:13:54
Perform a Huge Number of String Comparisons with esProc
-
-
-
-
-
-
blackduckie • Application • 583 View • 2020-01-12 16:03:37
Multistep Complex SQL Queries Optimization Example
-
-
blackduckie • Application • 580 View • 2020-01-08 14:58:54
Order-based Calculations: Conditional Query involving Multi-fields
-
blackduckie • Application • 699 View • 2020-01-08 11:46:14
Pass a Multi-value Parameter to BIRT’s SQL Data Set
-
blackduckie • Application • 623 View • 2020-01-08 09:50:42
Display Aggregates from Two Tables Side by Side
