Purpose: To delete duplicate rows from Table. There are many ways to do this, but i can remember this right now..
delete from table_name A where A.rowid > (select min(B.rowid) from table_name B where A.col = B.col);
No comments:
Post a Comment