查询某个字段重复的sql：

方法1：
select a.name from user a where a.name in
(select b.name from user b group by b.name having count(*) > 1)
方法2：
select a.name ,count(1) from user a
group by a.name having count(1) > 1 order by count(1) desc;