2019年5月15日
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=... 阅读全文
posted @ 2019-05-15 11:53 雨V幕 阅读(296) 评论(0) 推荐(0)