Answers for "write sql query to find duplicate rows in a database? and then write sql query to delete them?"

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 "write sql query to find duplicate rows in a database? and then write sql query to delete them?"