After "SQL," enter "select * from names;" to see your rows. After "SQL'" enter "delete from names a where rowid > (select min(rowid) from names b where b.name=a.name and b.age=a.age);" to delete the duplicate records. Once you have completed the above steps, enter "select * from names;" and then "commit" in order to check that you have deleted the duplicate records successfully.    SQL > select * from names; NAME                                  AGE ------------------------------ ---------- Alan                                   50 Carrie                                 51 Tom                                    52 Alan                                   50 rows selected. SQL > delete from names a where rowid > (select min(rowid) from names b where b.name=a.name and b.age=a.age ); row deleted. SQL > select * from names; NAME                                  AGE ------------------------------ ---------- Alan                                   50 Carrie                                 51 Tom                                    52 rows selected. SQL > commit; Commit complete.
अपनी लाइन (row) सिलेक्ट करें: डुप्लीकेट रो को उनके कॉलम से पहचानकर डिलीट करें: डुप्लिकेट्स के लिए चेक करें: