mysql查询某字段出现次数大于n的所有数据信息,还有对列出前三位
1.查出分数出现次数在三次以上的所有信息 SELECT * FROM test where `分数` in (SELECT `分数` FROM test GROUP BY `分数` HAVING COUNT(`分数`)>3)2.查出分数次数出现次数在前三的信息a SELECT `分数` FROM test GROUP BY `分数` HAVING COUNT(`分
原创
2016-03-23 21:56:24 ·
16583 阅读 ·
0 评论