【原创】使用Oracle分析函数去除重复记录

1、创建个实验表

create table t (a number);
insert into t values(1);
insert into t values(1);
insert into t values(1);
insert into t values(2);
insert into t values(2);
insert into t values(3);

commit;

2、可以使用下列SQL去除重复记录

delete t where rowid in
(
select rowid,a,b from
(
select a,lead(a,1) over (partition by a order by a) as b from t
)
where a=b
);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/498744/viewspace-242646/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/498744/viewspace-242646/