Posted On: Dec 17, 2020
SQL query to remove the duplicate record from a table is as follows:
DELETE FROM Table_name WHERE fieldname1 NOT IN ( SELECT MAX(fieldname1) FROM Table_name GROUP BY FieldName2, FieldName2 );
You can also find the distinct values from the tables by using the following query: Select distinct columnName from Table_name;
Never Miss an Articles from us.