how to delete all duplicate records from a table using
subquery?
Answer Posted / maninder
delete from abc where rowid not in (select max(rowid) from
abc group by column_name_with_dup.values.);
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
Whats the benefit of dbms_stats over analyze?
What is dual table oracle?
What is an oracle function?
What is the usage of merge statement?
How to select some columns from a table in oracle?
What is the difference between view and materialized view in Oracle?
what is port in oracle? how is it related to database application.
How would you change old and new values in an insert, delete and update triggers?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What do you mean by redo log file mirroring?
State and explain about oracle instance?
How to install oracle odbc drivers?
What is the fastest query method to fetch data from the table?
Hi Can any one tell me what are the API's used in requisition import.
What is concurrency in oracle?