oracle 同样数据删除(仅仅留一条)
时间:2022-03-14 00:42
DELETE FROM reg_user t1 WHERE user_name='9527008' and rowid > ( SELECT min(rowid) FROM location t2 WHERE t1.user_name= t2.user_name);
时间:2022-03-14 00:42
DELETE FROM reg_user t1 WHERE user_name='9527008' and rowid > ( SELECT min(rowid) FROM location t2 WHERE t1.user_name= t2.user_name);