回答:sql serverhttps://blog.csdn.net/Cxy_357/article/details/82190771?utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.no_search_link&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.no_search_link mysql结果CREATE TABLE ForgeRock ( varchar(13), varchar(57), int);INSERT INTO ForgeRock (, , )VALUES ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90), ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90), ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90), ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90), ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90), ('OpenIDM', 'Platform for building enterprise provisioning solutions', 60), ('OpenAM', 'Full-featured access management', 80), ('OpenDJ', 'Robust LDAP server for Java', 90) ;-- visit ForgeRock.com for details on the Open Identity Stack-- sqlfiddle.com is built with OpenIDMSELECT productName, = stuff(( select ',' + convert(nvarchar(255),aa) from ForgeRock t where t.productName = ForgeRock.productName for xml path('')), 1, 1, '')FROM ForgeRock group by productName