sql for xml path 和group_concat
时间：2021-07-01 10:21:17
帮助过：2人阅读
sqlserver*/
select Id,AId,(
SELECT IMEI
+‘,‘ FROM Device
as s
WHERE s.Id
=c.Id
For XML Path(
‘‘))
AS IMEI
from Device
as c
/*mysql*/
select AId,(
SELECT group_concat(IMEI)
FROM Device
as s
WHERE s.AId
=c.AId )
AS IMEI
from AccountSettings
as c
sql for xml path 和group_concat
标签：cat style info span png concat class from pat
