select
array_to_string(array_agg(astime order by astime),',') resTime,
array_to_string(array_agg(asdata1 order by astime),',') resData1,
array_to_string(array_agg(asdata2 order by astime),',') resData2
from
表
pgsql实现mysql group_concat的方式
于 2023-01-06 17:00:47 首次发布