SELECT
t.xm, t.sfzh, ARRAY_JOIN(ARRAY_AGG(DISTINCT t.rylx), ',') rylx -- presto
t.xm, t.sfzh, GROUP_CONCAT(t.rylx, ',') rylx -- mysql
t.xm, t.sfzh, CONCAT_WS(',', COLLECT_SET(t.rylx)) rylx -- hive
t.xm, t.sfzh, LISTAGG(t.rylx, ',') WITHIN GROUP (ORDER BY t.rylx) AS rylx -- oracle
FROM
(SELECT xm, sfzh, rylx FROM table1) t
GROUP BY
t.xm, t.sfzh
数据库多行合并为一列
最新推荐文章于 2024-04-26 16:12:33 发布