select ip,count() from ceshi where group by ip HAVING count() > 2 order by count(*) DESC limit 10
mysql 对表中的数据分组计算数量
最新推荐文章于 2024-06-08 10:15:00 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
select ip,count() from ceshi where group by ip HAVING count() > 2 order by count(*) DESC limit 10