mysql5.7多字段删除重复数据

最新推荐文章于 2023-04-12 16:58:36 发布

Dorothyho

最新推荐文章于 2023-04-12 16:58:36 发布

阅读量623

点赞数 1

分类专栏： Java

本文链接：https://blog.csdn.net/qq_34265112/article/details/86628125

版权

Java 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

DELETE
FROM
t_office_country
WHERE
(office_code, country_code) IN (
SELECT
t.office_code,
t.country_code
FROM
(
SELECT
office_code,
country_code
FROM
t_office_country
GROUP BY
office_code,
country_code
HAVING
count(1) > 1
) t
)
AND id NOT IN (
SELECT
dt.id_min
FROM
(
SELECT
min(id) AS id_min
FROM
t_office_country
GROUP BY
office_code,
country_code
HAVING
count(1) > 1
) dt
)