select * from chat where nickname in (select nickname from chat group by nickname having count(nickname)>1);
sql查询某字段出现的次数
最新推荐文章于 2023-06-23 16:27:02 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
select * from chat where nickname in (select nickname from chat group by nickname having count(nickname)>1);