I need to retrieve data from multiple records and store it into a single column seperated by ';'.
For example, the table test_vt has column A and two records.
I need to select column A from this table and store into another table test_vt1 as below.
Can you please help me with this?
sel oreplace(oreplace(tdstats.udfconcat(trim(cast(a as char(10)))),'"'),',',';') from tbl;