删除pop_code重复的记录
DELETE FROM delivery_plan_product WHERE pop_code in
(SELECT pop_code FROM delivery_plan_product GROUP BY pop_code HAVING COUNT(pop_code) > 1)
and delivery_plan_product_id not in
(SELECT min(delivery_plan_product_id) FROM delivery_plan_product GROUP BY pop_code HAVING COUNT(pop_code)>1)
DELETE FROM delivery_plan_product WHERE pop_code in
(SELECT pop_code FROM delivery_plan_product GROUP BY pop_code HAVING COUNT(pop_code) > 1)
and delivery_plan_product_id not in
(SELECT min(delivery_plan_product_id) FROM delivery_plan_product GROUP BY pop_code HAVING COUNT(pop_code)>1)