假设有一个student表里有2个字段分别是 sname和score 求分数相同的的所有信息。

select sname ,score from student where score
in (select count(sname) from student where count(sname)>1 group by score )