1 测试表数据
SELECT role_no
FROM pmpdb.tb_userrole_info;
role
------
01
02
03
2 列转行写法
写法1:(string_agg)
SELECT user_no, string_agg (role_no, ',') as role_no
FROM pmpdb.tb_userrole_info
GROUP BY user_no;
role_no
------------
01,02,03
写法2: array_to_string(ARRAY_AGG (text),',')
SELECT user_no, array_to_string(ARRAY_AGG (DISTINCT role_no), ',' ) as role_no
FROM pmpdb.tb_userrole_info
GROUP BY user_no;
role_no
------------
AA,BB,CC
———————————————