select t1.name from (select sum(score) as sum_score, name from table GROUP BY name ) as t1 , (select sum(score) as sum_score, name from table GROUP BY name ) as t2 , where t1.sum_score=t2.sum_score and t1.name!=t2.name;

相关推荐

牛客网
牛客企业服务