sql for xml path 和group_concat 

/*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

 

posted @ 2019-05-15 11:53  雨V幕  阅读(281)  评论(0)  编辑  收藏  举报