with tmp_table as (
select ‘a’ name1,‘A’::varchar as t union all
select ‘a’ name1,‘B’::varchar as t union all
select ‘a’ name1,‘C’::varchar as t
)
select name1,array_agg(t) t1,string_agg(t,’,’) t2
from tmp_table
group by name1;
postgresql 列转行
最新推荐文章于 2024-05-14 13:47:03 发布