select a.xxx,
regexp_replace(listagg(b.area_proname,',') within group(order by b.area_proname),'([^,]+)(,\1)+', '\1') as area_proname
from table_1 a,
table_2 b
where a.xx = b.xx
listagg函数:正则表达式去重
最新推荐文章于 2023-03-08 11:13:34 发布
select a.xxx,
regexp_replace(listagg(b.area_proname,',') within group(order by b.area_proname),'([^,]+)(,\1)+', '\1') as area_proname
from table_1 a,
table_2 b
where a.xx = b.xx