Technical Blog
Pages
(Move to ...)
Home
Oracle DBA
ERP
Oracle Apps
Data Warehouse
Java
UNIX
Hadoop
JOBS4U
▼
Showing posts with label
Delete Duplicates
.
Show all posts
Showing posts with label
Delete Duplicates
.
Show all posts
Jan 9, 2009
To delete duplicate records
›
DELETE FROM INTERSECTION e WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM INTERSECTION f WHERE e.NUM = f.NUM AND E.NAME=F.NAME); This que...
›
Home
View web version