DELETE FROM TAB1 A
WHERE ROWID > (SELECT MIN(ROWID) FROM TAB1 B
WHERE A.COL1=B.COL1
AND A.COL2=B.COL2
AND A.COL3=B.COL3
........)
Here TAB1 is the name of table and COL1, COL2, COL3.... are the names of the columns that make primary key for the table.
Sanjay




Reply With Quote