删除:Delete from table where Empid not in (select Empid from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name))
显示一行: select NAME from table group by NAME having count(NAME ) > 1
显示重复行中所有记录select * from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name)
删除:Delete from table where Empid not in (select Empid from table where name in (select NAME from table group by NAME having count(NAME ) > 1 group by name))