Answers for "how to delete duplicate records in a table"

Query to remove duplicate rows from a table

DELETE FROM Customers WHERE ROWID(SELECT MAX (rowid) FROM Customers C WHERE CustomerNumber = C.CustomerNumber);

Posted by: Guest on November-19-2021

Code answers related to "how to delete duplicate records in a table"