Write sql query to remove the duplicate record from a table.

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;