id type note
100 I ABC
100 O A123
100 D E321
101 I ABD
数据如上,我想得到以下结果 (id为100):
id memo
100 I:ABC/O:A123/D:E321
谢谢大侠!
id type note
100 I ABC
100 O A123
100 D E321
101 I ABD
数据如上,我想得到以下结果 (id为100):
id memo
100 I:ABC/O:A123/D:E321
谢谢大侠!
SELECT id, LISTAGG(type || ':' || note, '/') WITHIN GROUP AS MergedTypeNote
FROM TableName
GROUP BY id;
试一下看看