|
|
|
|
Re: How to identify one row from duplicate rows [message #659479 is a reply to message #659478] |
Wed, 18 January 2017 11:53 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
Every row has a unique rowid, so try the following (use the correct table name and columns that determine your duplicate rows.
delete from my_table a
where
a.rowid <>
(select max(rowid) from my_table b
where b.key1 = a.key1
and b.key2 = a.key2
and b.key3 = a.key3);
If the entire row is duplicated then you can do something like
create table rebuild_my_table as
select distinct *
from my_table;
truncate table my_table;
insert into my_table select * from rebuild_my_table;
commit;
drop refresh_my_table;
[Updated on: Wed, 18 January 2017 11:54] Report message to a moderator
|
|
|
|
|