DELETE from cust_hk where
-- 删除所有的重复时间 Begin --
`客户编码` in (
SELECT `客户编码` from (SELECT `客户编码` FROM `cust_hk` GROUP BY `客户编码` HAVING COUNT(`客户编码`) > 1) tmp2
)
-- 删除所有的重复时间 END --
-- 但一些特定ID的记录不进行删除 Begin --
AND
id NOT in(
select id from (
SELECT MIN(id) id FROM `cust_hk` GROUP BY `客户编码` HAVING COUNT(`客户编码`) > 1
) tmp1
)
20240521每日后端--------聊聊删除重复数据保留一条
最新推荐文章于 2024-10-27 16:50:16 发布