当前位置：首页 > 数据库 > 正文

sql for xml path 和group_concat

yunbo1
数据库
2026-09-05
192

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

上一篇
mysql5.7 mysql库下面的user表没有password字段无法修改密码

下一篇
使用yum时出现Error: rpmdb open failed解决方案

最新文章