LovePythonMM的博客

select nation,listagg(city,',') within GROUP (order by city)  from temp  group by nation   这是最基础的用法：LISTAGG(XXX,XXX) WITHIN GROUP( ORDER BY XXX)用法就像聚合函数一样，通过Group by语句，把每个Group的一个字段，拼接起来。...

select column_value from table(fun_split('180,200', ','));