oracle 全网相同数据删除(只留一条)
时间:2022-03-13 23:25
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-13 23:25
DELETE FROM reg_user t1 WHERE user_name='9527008' and rowid > ( SELECT min(rowid) FROM location t2 WHERE t1.user_name= t2.user_name);