第二道SQL: select t2.dd, sum(if (uid2 in (t2.dd) or uid1 in(t2.dd),value,0)) from 原表 t1 join (select distinct uid2 dd from 原表 where uid1 = 1) t2 where uid1 = t2.dd or uid2 = t2.dd group by t2.dd
点赞 评论

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务