select count(name) ,name from user group by name having count(name)>1
SQL 查询一个字段所有的之出现次数大于1的条数
最新推荐文章于 2024-07-05 02:16:24 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
select count(name) ,name from user group by name having count(name)>1