DELETE FROM person
WHERE id IN (
SELECT id
FROM (
SELECT id, NAME, ROW_NUMBER() OVER(PARTITION BY NAME ORDER BY NAME) AS rn FROM person
) t
WHERE t.rn > 1
);
mysql删除表里面的重复数据保留一条
最新推荐文章于 2024-06-28 23:04:57 发布