All Forums Analytics
andersom 1 post Joined 11/14
18 Nov 2014
HOW ? Vertical Merger Turn Standard SQL?

HOW ? Vertical Merger Turn Standard SQL?
1 AAAA 1030101
1 BBBB 1030101
1 CCCC 1031201
1 DDDD 1030901 
--------------------------------------
1 AAAA 1030101,BBBB 103010,CCCC 1031201,DDDD 1030901
 

Raja_KT 1246 posts Joined 07/09
18 Nov 2014

You can try thus, say:
select id1,regexp_replace(tdstats.udfconcat(trim(name||id2)),'"','',1,0,'c') from your_tabul. group by 1

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.