SELECT * FROM test.employee;
insert into employee(id,name)values(1,'tom');
insert into employee(id,name)values(2,'tom');
insert into employee(id,name)values(3,'jack');
select name,count(name) from employee group by name having count(name)>1

参考以上sql ,分组后记录数超过1即为同名。