PostgreSQL 列转行问题

大家好，又见面了，我是你们的朋友全栈君。

1 测试表数据

SELECT relative_label_content FROM frk_s.label_cor_gene

relative_label_content

——

AA

BB

CC

2 列转行写法

写法1：（string_agg）

SELECT frwybs, string_agg (relative_label_content, ‘,’) as relative_label_content FROM frk_s.label_cor_gene GROUP BY frwybs

relative_label_content

————

AA,BB,CC

写法2： array_to_string(ARRAY_AGG (text),’,’)

SELECT frwybs, array_to_string( ARRAY_AGG (DISTINCT relative_label_content), ‘,’ ) as labels_content FROM frk_s.label_cor_gene GROUP BY frwybs

labels_content

————

AA,BB,CC

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/148912.html原文链接：https://javaforall.cn