方法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;
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;