Answers for "how to avoid insert duplicate records in sql"

how to query without duplicate rows in sql

SELECT DISTINCT col1,col2... FROM table_name where Condition;

Posted by: Guest on October-02-2020

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 avoid insert duplicate records in sql"