一个表cuslist,有两列customer和manager,想把第一列合并,但是要把第二列不重复的值通过字符串加起来
请问怎么实现可以达到以下这种效果
求大佬们帮忙解答一下,不胜感激
SELECT customer, [ manager] = STUFF (( SELECT ' , ' + [ manager] FROM tb t WHERE t.customer= tb.customer FOR XML PATH( '' )), 1 , 1 , '' )
FROM tb
GROUP BY customer
-- MySQL
SELECT customer,GROUP_CONCAT(management) FROM cuslist GROUP BY customer;
-- 测试数据
INSERT INTO cuslist
VALUES ('IBM', '3'),
('IBM', '4'),
('IBM', '5'),
('IBM', '6'),
('MicroSoft', '7'),
('MicroSoft', '8'),
('MicroSoft', '9'),
('Apple', '10');
-- 结果
Apple,10
IBM,"3,4,5,6"
MicroSoft,"7,8,9"