根据字段source_city,source_state,source_country进行查询重复项
SELECT * FROM
(SELECT COUNT(*) as num,source_city,source_state,source_country,min(id) as id FROM dim_poi_location GROUP BY source_city,source_state,source_country)e
WHERE e.num>1;
根据字段source_city,source_state,source_country进行重复项的删除
DELETE FROM dim_poi_location
WHERE id IN
(SELECT id FROM (SELECT id FROM dim_poi_location GROUP BY source_city,source_state,source_country HAVING count(*) > 1)e);