首页 > 代码库 > oracle 同样数据删除(仅仅留一条)

oracle 同样数据删除(仅仅留一条)

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 同样数据删除(仅仅留一条)