2011年6月8日
查找/删除重复记录
摘要： 查找相当记录及个数: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) 阅读全文
posted @ 2011-06-08 16:32 草根站长李小冲 阅读(152) 评论(0) 推荐(0) 编辑