SQL：
SELECT group_concat(name,',',remark order by id desc separator ';') FROM test group by age;
運(yùn)行結(jié)果：
2.oracle:
wmsys.wm_concat函數(shù),功能比較簡單,只能實(shí)現(xiàn)單字段間的合并,demo如下：
表數(shù)據(jù)：
SQL:
SELECT DISTINCT
wmsys.wm_concat (NAME) OVER (
PARTITION BY AGE
ORDER BY
(SELECT 1 FROM dual)
)
FROM
(
SELECT
*
FROM
T_TEST
ORDER BY
ID DESC
) T
結(jié)果：
3.Postgresql:array_to_string以及
string_agg兩個(gè)函數(shù)都能實(shí)現(xiàn),推薦string_agg,demo如下:
表數(shù)據(jù):
SQL：
SELECT id,array_to_string(ARRAY(SELECT unnest(array_agg(name)) order by 1),';') FROM t_kenyon GROUP BY id ORDER BY id;
SELECT id,string_agg(name,';') FROM t_kenyon GROUP BY id ORDER BY id;
結(jié)果：
