删除重复数据
数据库删除重复数据1.mysql去重2.sqlservice去重3.oracle去重
1.mysql去重
delete
FROM
table_name
WHERE
(cloimn1,cloimn2) IN (
SELECT
t.cloimn1,t.cloimn2
FROM
(
SELECT
cloimn1,cloimn2
FROM
table_name
GROUP BY
cloimn1,cloimn2
HAVING
count(1) > 1
) t
)
AND ID NOT IN (
SELECT
原创
2021-05-31 16:22:49 ·
106 阅读 ·
1 评论