MySQL 查询计数并删除结果

Question

我有美国所有邮政编码的列表。我需要删除未出现在多个县的邮政编码。

我创建了以下查询，它能够提取我不需要的所有邮政编码，但现在我需要删除它们。

SELECT zipcode, COUNT(countyname) FROM enrollmy_healthr.`table 10`
group by zipcode having count(zipcode)>1;

预先感谢您提供的任何帮助。

问候，

Answer 1

这个方法可以帮助你

Delete from enrollmy_healthr.`table 10` where zipcode in 
(select * from (SELECT e.zipcode FROM enrollmy_healthr.`table 10` e 
group by e.zipcode having count(e.zipcode)>1) tmp )