code name ......... ab Amritha ........ ab Amritha ........ ac Tintu ....... ac Tintu .......
code name ...... ad Amritha ........ ac Tintu .........
SQL> DELETE FROM table_name A WHERE ROWID > ( SELECT min(rowid) FROM table_name B WHERE A.key_values = B.key_values);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)