HOW ? Vertical Merger Turn Standard SQL?

Analytics

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

1 REPLY
Enthusiast

Re: HOW ? Vertical Merger Turn Standard SQL?

You can try thus, say:

select id1,regexp_replace(tdstats.udfconcat(trim(name||id2)),'"','',1,0,'c') from your_tabul. group by 1