//SQL SERVER方法
(STUFF((select ','+ verifyUser from SER_INFOVERIFY x WHERE x.appCode = a.appCode for xml path ('')),1,1,'')) as appUserStr
STUFF((查询结果 for xml path ('')),1,1,'')
//MYSQL 方法
SELECT GROUP_CONCAT(a.REGION_ID) FROM t a;
SELECT GROUP_CONCAT(表别名.列) FROM 表表达式 表别名;
【SQL】将查询结果转换为字符串
于 2022-11-29 11:06:17 首次发布