Application  • 
                                    712 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) big data(9) mysql(8) topn(6) hive(2) oracle(2) enum value(1) mysql headache(1) compare same period(1) conditional change(1) overlapping(1) continuous equivalence(1)
                
sql(179) text(125) json(28) sql headache(24) group(18) java(14) xml(13) transpose(10) web service(9) big data(9) mysql(8) topn(6) hive(2) oracle(2) enum value(1) mysql headache(1) compare same period(1) conditional change(1) overlapping(1) continuous equivalence(1)
- 
    
    
- 
    xingjl • Application • 708 View • 2020-03-05 16:45:04* Implement overlapping grouping from MySQL in one line
- 
    xingjl • Application • 692 View • 2020-03-05 16:47:37* Implement the ordered enumeration conditional grouping from MySQL in one line
- 
    xingjl • Application • 664 View • 2020-03-05 16:53:33. Implement grouping by conditional change from MySQL in one line
- 
    xingjl • Application • 667 View • 2020-03-05 16:53:40Implement grouping by continuous equivalence from MySQL in one line
- 
    xingjl • Application • 605 View • 2020-03-05 16:52:23Take the top three of each group from MySQL in one line
- 
    xingjl • Application • 791 View • 2023-11-29 21:33:25Take the top three of each group from Hive in one line
- 
    xingjl • Application • 558 View • 2020-03-05 16:51:57Take the top three of each group from Oracle in one line
- 
    xingjl • Application • 849 View • 2020-03-05 16:51:25One line code to get same period ratio which is hard to get in SQL
- 
    xingjl • Application • 866 View • 2020-03-05 16:49:32* Row and column transposition of dynamic columns in one line
- 
    
    
- 
    
    
- 
    blackduckie • Application • 1,136 View • 2020-01-17 16:58:32Group & Concatenate MongoDB Subdocuments
- 
    
- 
    blackduckie • Application • 628 View • 2020-01-17 15:50:17Get & Concatenate MongoDB Subdocuments by a Condition
- 
    
    
- 
    
    
- 
    blackduckie • Application • 651 View • 2020-01-17 11:28:56Dynamic Conversion of JSON to Table Sequence
- 
    
    
- 
    blackduckie • Application • 641 View • 2020-01-19 17:25:24Row-to-Column Transposition & Dynamic-column-based Enumerated Grouping
- 
    blackduckie • Application • 548 View • 2020-01-15 07:13:54Perform a Huge Number of String Comparisons with esProc
- 
    
    
- 
    
    
- 
    
    
- 
    
    
