oracle去除重复数据sql
?
delete
table1
where
rowid
not
in
(
2
select
max
(rowid)
from
table1
group
by
col1 ,col2,col3 )
发布时间: 2012-07-02 17:46:22 作者: rapoo
oracle去除重复数据sql
?
delete
table1
where
rowid
not
in
(
2
select
max
(rowid)
from
table1
group
by
col1 ,col2,col3 )