pg 企查查曾用名 列传行

unnest(string_to_array(concat_ws('；',used_nm),'；')) as tab_interest

oracle 行转列 

listagg(city,',') within GROUP (order by city) over (partition by nation) rank