SQL: How to Identify and Remove Duplicate Records from a Table? Part3
Method 2 : Using ROWID with Self Join
In this method we need not to group the records.
/*Actual Query - Keep the records having maximum ROWID for combination or records and remove rest of the records*/
Delete From DupTest T1
where ROWID NOT IN
(Select MAX(ROWID) From DupTest T2 where T1.ID=T2.ID);
/*Check the result now*/
Select * From DupTest Order By ID;
#GoLearningPoint
For Interview questions and other topics -
https://tipsfororacle.blogspot.com/