sqlserver:
SELECT
*,
( SELECT Hospitalproperty2 + ‘ ‘ FROM testtable WHERE Hospitalproperty = ‘zhangs‘ FOR XML path ( ‘‘ ) )
FROM
testtable
MySQL：
select *,(select GROUP_CONCAT(b.Hospitalproperty2)from testtable b) from testtable;
sqlserver:
SELECT
*,
( SELECT Hospitalproperty2 + ‘ ‘ FROM testtable WHERE Hospitalproperty = ‘zhangs‘ FOR XML path ( ‘‘ ) )
FROM
testtable
MySQL：
select *,(select GROUP_CONCAT(b.Hospitalproperty2)from testtable b) from testtable;
原文：https://www.cnblogs.com/wangpeng00700/p/8422523.html