从表中删除重复记录的SQL语句?

有一个表,假设是这样的
CREATE TABLE Test (
field1 number(7) primary key,
field2 varchar2(30)
);
假设field1上有索引。
要删除表中所有field1重复的记录,可以用下面的SQL语句:
---------------------------------------------------------------

delete from Test a where a.rowid!=(select max(rowid) from Test b where a.field1=b.field1);

---------------------------------------------------------------

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus