Delete duplicate records in tables without primary keys

Delete duplicate records in tables without primary keys

Create procedure delrepeat

As
Begin
SELECT distinct * INTO testTemp FROM test
Delete from test
Insert into test SELECT * FROM testTemp
Drop table testTemp
End

Distinct: used to remove duplicate items in a query

Begin ~ End range statement indicates the block used as the whole execution in the stored procedure.

Oracle database tutorial

Delete from a1 where rowid not in (select max (rowid) from a1 group by aa, bb, cc); -- it is processed by the rowid of the physical row number, which is very active and usable :)
Ern posts

Use a temporary table
 
Create table TMP_TABLE select distinct * FROM TABLE_NAME;
DROP TABLE_NAME;
Create table TABLE_NAME SELECT * FROM TMP_TABLE;
DROP TMP_TABLE;
COMMIT;