CODE EXAMPLE FOR SQL

Query to remove duplicate rows from a table

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