1.查出分数出现次数在三次以上的所有信息&
SELECT * FROM test where `分数` in (SELECT `分数` FROM test& GROUP BY `分数` HAVING COUNT(`分数`)&3)
2.查出分数次数出现次数在前三的信息
a&&&& SELECT `分数` FROM test& GROUP BY `分数` HAVING COUNT(`分数`)&=2 ORDER BY (COUNT(`分数`)) DESC LIMIT 0,3& ？？？？
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：991次
排名：千里之外}