SQL 找出一字段中所有重复的记录

SQL 找出一字段中所有重复的记录

SELECt * FROM 表名
group by 字段
having count(字段)>1

select 字段名,count(字段名) from 表名 group by 字段名 having count(字段名)>1

select q.* from (select count(1),kkk from table a group by kkk having count(1)>1) p,a q where p.kkk=q.kkk;

你好！ 假设你的字段是A select A,count(A) as num from table group by A having count(A)>1 打字不易，采纳哦！