17,382
社区成员




regexp_replace(listagg(sc.cityfrom || sc.addfrom, '-->')
within group(order by sc.city_seq),
'([^,]+)(-->\1)+',
'\1') as addfrom--这个没问题,下面又加了点内容就有重复项了
regexp_replace(listagg(sc.cityfrom || sc.addfrom||','||sc.remark, '-->')
within group(order by sc.city_seq),
'([^,]+)(-->\1)+',
'\1') as addfrom,