MySql查询表中有多少条重复的表字段

select '字段名',count(*) as c from '表名'group by '字段名'having c>1; 是不是大于1
例子:
select team_name,count(*) as c from team group by team_name having c>1;

很简单的一条sql语句,基本上拿来即用~

欢迎大家评论区讨论,看到一定秒回!