mysql查询某字段出现次数大于n的所有数据信息，还有对列出前三位

1.查出分数出现次数在三次以上的所有信息 

SELECT * FROM test where `分数` in (SELECT `分数` FROM test  GROUP BY `分数` HAVING COUNT(`分数`)>3)SELECT * FROM test