Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
...
Breaking News
Friday, December 9, 2011
how to find and delete duplicate records in oracle
// For Select duplicate records
select *
from table_Name group by key1, key2
having count (*) > 1;
// For delete duplicate records
delete from test a
where rowid <>...
Subscribe to:
Posts
(
Atom
)