Delete all duplicate records using subquery - oracle

How to delete all duplicate records from a table using subquery?

Query:
DELETE from table1 where rowid not in (select MAX(rowid) from table1 GROUP BY column_name);
Here, column_name should be the column having duplicate values.
Types of trigger can be used in a table at a time - oracle
Types of trigger can be used in a table - We can use maximum of 12 triggers on a table. • BEFORE INSERT • AFTER INSERT...
What is partitioned table? What are its types and purposes? - oracle
Partitioned table - Partitioning allows decomposing large tables and indexes into smaller manageable units called partitions...
What is the role of Archiver [ARCn]? - oracle
What is the role of Archiver [ARCn]? - ARCn is an oracle background process responsible for copying the entirely filled online redo log file to the archive log...
Post your comment

Related Content

Follow us

▲