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
);

[@more@]

使用Oracle分析函式去除重複記錄

相關文章