首先看一下表中的数据 select t.* from student t where (select count(*) from student where age=t.age and score=t.score)>1; 执行结果如下: