删除重复sql语句|一句话删除重复sql语句

删除重复sql语句|一句话删除重复sql语句

delete from companys where Gid not in(select Min(Gid) from companys group by 公司名称)