查找/删除重复记录

查找相当记录及个数:

SELECT COUNT(CNAME),CNAME FROM tblCompany GROUP BY CNAME HAVING (COUNT(*) > 1)

 

删除相当记录：

delete tblCompanyTemp where ID not in (
select max(ID) from tblCompanyTemp group by CNAME)