select o.ci_id, max(coords) as coords from (
select ci_id, replace(replace(wm_concat(loc_x||'&'||loc_y) over(partition by ci_id order by ci_num), ',',';'),'&',',') as coords
from p_ci_coor_group_0416 t) o group by o.ci_id
结果:
1 116.900724,38.70797327;116.9067092,38.70886007;116.9069536,38.70810234;116.9008741,38.70503701;116.900724,38.70797327