大家好,又见面了,我是你们的朋友全栈君。
SELECT relative_label_content FROM frk_s.label_cor_gene
relative_label_content
——
AA
BB
CC
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
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