通过group by结合使用 string_agg函数
SELECT kk.“号码”,
kk.“计数”,
string_agg(kk.“属性”, ‘,’::text) AS string_agg
FROM ( SELECT ss.“号码”,
count(*) OVER (PARTITION BY ss.“号码”) AS “计数”,
ss.“属性”
FROM ( SELECT “市场部0330需更换终端用户明细”.“号码”,
‘需更换终端用户’::text AS “属性”
FROM “市场部0330需更换终端用户明细”
UNION
SELECT “市场部0330需升级终端版本打开VoLTE开关更换卡槽”.“号码”,
‘需更换卡槽’::text AS “属性”
FROM “市场部0330需升级终端版本打开VoLTE开关更换卡槽”) ss) kk
GROUP BY kk.“号码”, kk.“计数”
ORDER BY kk.“计数” DESC