DELETE
FROM reg_user t1
WHERE user_name='9527008' and rowid > ( SELECT min(rowid)
FROM location t2
WHERE t1.user_name= t2.user_name);
oracle 相同数据删除(只留一条)
最新推荐文章于 2024-05-16 21:05:49 发布
DELETE
FROM reg_user t1
WHERE user_name='9527008' and rowid > ( SELECT min(rowid)
FROM location t2
WHERE t1.user_name= t2.user_name);